October 6, 2011 at 8:13 am
Hi,
I am trying to enter an application on a client PC, (application is MS Dynamics GP which uses sql server logins)
When I try to enter the password, it says
Login failed. Contact your system adminsitrator.
I checked the sql logs which say
Error: 18456, Severity: 14, State: 8.
I checked and made sure that the password is correct from SSMS.
I dont have a clue why is it failing?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
October 6, 2011 at 8:27 am
check if you have a default database set for this login ID.
October 6, 2011 at 8:27 am
Connecting to the wrong server? Caps lock on? Fat fingers? You're really going to have to work this one out for yourself, since none of us know what your password is. What do you mean you checked from SSMS? Try changing the password so that you know exactly what it is and then logging in again.
John
October 6, 2011 at 8:32 am
cindyaz (10/6/2011)
check if you have a default database set for this login ID.
Yes, the default database is master.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
October 6, 2011 at 8:34 am
John Mitchell-245523 (10/6/2011)
Connecting to the wrong server? Caps lock on? Fat fingers? You're really going to have to work this one out for yourself, since none of us know what your password is. What do you mean you checked from SSMS? Try changing the password so that you know exactly what it is and then logging in again.John
I chekced from ODBC, the server is right.
Caps lock off
I changed password from SSMS and then try to log in with changed password and it is not going in.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
October 6, 2011 at 8:53 pm
SKYBVI (10/6/2011)
Hi,I am trying to enter an application on a client PC, (application is MS Dynamics GP which uses sql server logins)
When I try to enter the password, it says
Login failed. Contact your system adminsitrator.
I checked the sql logs which say
Error: 18456, Severity: 14, State: 8.
I checked and made sure that the password is correct from SSMS.
I dont have a clue why is it failing?
Regards,
Sushant
Was the user account created through Dynamics? We found that the application would fail unless the account was created through dynamics.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply