Saturday, January 2, 2010

Login failed for user 'SomeUser'. (Microsoft SQL Server, Error: 18456)

You can get the "Login failed for user 'SomeUser'. (Microsoft SQL Server, Error: 18456)" error when you connecting from SQL Server Management Studio for the first time.

To solve the problem right-click on SQL Server Management Studio shortcut and select 'Run as Administrator' and then connect to database.
You can add your windows login under Security/Logins to run the SQL Server Management Studio without 'Run as Administrator' option.

2 comments:

Поющие said...

What a pleasure reading such a nice comments ! :)) I have almost learnt chinese ))

Roman said...

Oh, yes, chinese spammers are most funny spammers. Nobody understands their messages, but they think they did a big trick