December 1, 2011 at 4:58 am
Hi All,
Sql server 2008 r2
Got below error when i have tried to login to server using sql login..
Login failed for user 'mysrvlist'. (Microsoft SQL Server, Error: 18456)
Error Number: 18456
Severity: 14
State: 1
December 1, 2011 at 5:51 am
Wrong password?
-- Gianluca Sartori
December 1, 2011 at 5:52 am
Hi,
Did you see error in sql server logs/error logs...
You might get more info from there.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
December 1, 2011 at 5:54 am
Also,
maybe the server is configured only for Windows authentication. IF it is, Turning on Windows+SQL server authentication can solve the problem.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
December 1, 2011 at 6:01 am
Hi..
I am sure i have entered correct pwd and also my server using mixed mode..
December 1, 2011 at 6:14 am
Did you check sql server logs/error logs and event log (Windows) to see if you can
get more detail of the error.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
December 1, 2011 at 7:16 am
Troubleshooting: Login Failed for User 'x'
http://msdn.microsoft.com/en-us/library/ms366351.aspx
FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"
December 1, 2011 at 7:27 am
SKYBVI (12/1/2011)
Did you check sql server logs/error logs and event log (Windows) to see if you canget more detail of the error.
Regards,
Sushant
Hi sushant
I have checked in sql server error log as well as windows event viewer its clearly says server is configured for windows authentication mode..
Actually am using client machine where i have configured for windows and sql server authentication mode ..
Thanks
December 1, 2011 at 7:30 am
Actually am using client machine where i have configured for windows and sql server authentication mode ..
We define authentication mode at Server Level. Client utility just passes the credentials.
December 1, 2011 at 7:31 am
its clearly says server is configured for windows authentication mode..
Try your windows logins to connect to server.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply