HEXAQ : A friendly question - answer site for IT professionals

Login failed for user 'suresh'. Microsoft SQL Server Error: 18456


0

I am trying to connect to my my SQL server 2008 R2 through SQL Server Management Studio.

I entered correct username and password but still gettign error.

Login failed for user 'suresh'. Microsoft SQL Server Error: 18456

I have restarted my computer but still I am unable to login.

Anyone can help?

Â
asked
 


≡ Total 2 Answers

0

Verify that you have enabled Mixed authentication mode in your db server.

If it is not enabled, you might get this error.

Â
replied


0

Hi Suresh,

Microsoft has a kb article for

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"

Take a look at the linkhttp://support.microsoft.com/kb/925744

Â
replied


Enter your reply here
Answer Preview:
Viewed: 610 times
Asked on: 7/3/2013
Permalink
Topics in this question
  19
Search Question
Similler Questions