Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have SQL Server 2005 SP3 running one server with mixed mode authentication. I tried to connect to the database engine, using the SQL Management Studio installed on the same machine. But I get a login error that says

Login failed for user *user*, (Microsoft SQL Sever, Error: 18456)

Strangely I'm able to connect to the Database through SQL Server Management Studio running on a different server. What am I doing wrong?

share|improve this question

4 Answers 4

Have you checked the logs?

Although the error message on screen is not very helpful there may be more helpful information in the log itself, in particular the State value.

Take a look here to see if this makes it any clearer.

Hope this helps.

share|improve this answer
    
LOL - Is there an echo in here...? –  DilbertDave Jul 31 '09 at 15:32

From Google:

Error 18456

share|improve this answer

Here's an article describing how you can look at the stat information in the server log for the corresponding error to get some mor information about the cause of the error message.

share|improve this answer
up vote 1 down vote accepted

Okay, I solved the problem myself. Thank you all for your answers. I found this link which solved the problem http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/ff81398a-c959-4d87-89b1-57f6aa843bab/

Basically, I started Reporting Services configuration by going to Start > Program > Microsoft SQL Server > Configuration Tools and connected to Reporting Server. Then filled out the information in Database setup node and clicked apply. After this I was able to use SQL Server Management Studio in the local machine to connect to the SQL server

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.