Tuesday, November 16, 2010

I’m typing in the correct password but SQL says login failed!

Did you notice that every task in Windows 2008 requires more clicks than Windows 2003? If you try to start the SQL Management Studio in Windows 2008, you’ll get the following error message.

Cannot connect to MYSQLSERVER\MYSQLINSTANCE. Additional information: Login failed for user ‘MyAdminAccount’. (Microsoft SQL Server, Error: 1846)


The extended error message is

TITLE: Connect to Server
Cannot connect to MYSQLSERVER\SQL001.
Login failed for user 'MYSQLSERVER\sqladmin'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

Cause: The cause is that you didn’t click enough! In Windows 2008, you have to use Run as administrator to launch the SQL Server Management Studio. What a deceptive error message!

No comments:

Post a Comment