I have seen a few related posts which I have tried to follow all suggested solutions, but have not found one for myself yet. I will try to list the information that I have and the results of the attempts.
Summary: Oracle server and client on the same 2003 server machine. Website on localhost, attempt to login using Windows Authentication and receive an ORA-1017 invalid username/password Error. For testing purposes I am using the administrator account for the machine.
I have created users in the database as both $OPSADMINISTRATOR and $OPSMYDOMAIN\ADMINISTRATOR.
I can login using SQLPlus /
I have turned on session auditing to view the username that is attempting to connect to the database, SQLPlus dependent upon SQLNET.AUTHENTICATION_SERVICES=(NTS) will login as one of the above, but both will login.
For my testing using ODP.NET I have the SQLNET.AUTHENTICATION_SERVICES=(NTS) set in the sqlnet.ora
Allowing teh website to attempt its login I receive ORA-1017 invalid username/password and in the dba_audit_session table the username is blank. Is this correct? I was not sure if the username was filled in by the OS and sent or if it stayed blank. The code connection string uses "User ID=/;" If the audit username is blank, is there a method of finding out what username is being authenticated?
If I create a test user to login and hard code the user name and password the website does connect appropriately.
I can use tnsping which shows me the sqlnet.ora that it is using and it is the appropriate client file, which also contains SQLNET.AUTHENTICATION_SERVICES=(NTS)
Using IIS Manager I right-click to get the properties fo the website folder. Directory Security has Integrated Windows Authentication checked and all other authentication methods unchecked.
Using regedit I looked to see Oracle_Home is set appropriately for the client and server.
I guess my first area of focus is the blank username. If that is correct and login fails does that mean the error is contained to the Windows side?
Is there another user/authentication/security setting?
I am running out of things to check so any ideas are welcome.