Hi!
I have msde (that installed with an application) on the old computer. Now I am setting up a new computer and I want to use SQL Express with this application so that I could easier manage databases.
I have installed SQL Express 2005, attached databases from the old computer, created an ODBC system data source and created user "AD" to use with this application.
Now when I try to log on with this program I get the following error message: Login failed for user 'AD'. In trace says it is "Error: 18456, Severity: 14, State: 8."
I have tried changing many settings, but it still doesn't work. So I would really appreciate if someone would help me troubleshoot this error.
Login failed for user...
GillianR
You can try to debug the application to see how it connects exactly.
You can also try to install a network monitor and examine the packets sent to SQL Server (assuming you're not using SSL).
If you can connect from Management Studio and if the password in the ODBC source is the same as what you used with Management Studio, then maybe the application is attempting to connect another way, maybe using a hardcoded password.
Thanks
Laurentiu
da5id
State 8 means that the password that you are using to connect is incorrect. Verify that you are using the correct password for login AD.
Thanks
Laurentiu
mgesing
Password I type is 100% correct. I can log in into Managment Studio with that user and password without any problems.
Can I see what does application actually send as a password Is there any way to trace it