stand alone application unable to connect to database

Ephetejew

New Member
We have a web based application which has web services (say user.asmx) which communicate with application database using generic credentials. In order to provide access to a user, we have an automation tool which uses the above web services and uses same credentials (as web application is using) and insert/update records in the application database.Here, we have a concern that there is a logon trigger on the database and is preventing the tool to communicate to database. While investigating the error log on database, we found the below error message:LOGON_TRIGGER: oerr, unhandled exception occurredLOGON_TRIGGER: user =>abcdefLOGON_TRIGGER: machine=>LOGON_TRIGGER: program=>W3WP.EXELOGON_TRIGGER: osuser =>IUSR_****LOGON_TRIGGER: -20001LOGON_TRIGGER: ORA-20001: [email protected] You are not allowed to loginDBA want us to investigate and get the machine name populated so that they can alter the trigger to allow this tool.Can experts please advise what could be the reason that machine name is not populating at the database level.
 
Back
Top