Sunday, February 12, 2012

Cannot connect to database using SQL Authentification !!!!!!

I cannot connect to my database using SQL Authentification for a user who is working fine. I know I'm putting the right username and password because I just recently logged in using Windows Authentification to my database, and retyped the password just to be sure it's right. I even tried createing a new sql login and tried that, no luck.

And yes, SQL is in mixed mode for Authentification as it has been all along.


error when trying to connect is:

TITLE: Connect to Server

Cannot connect to (local).

ADDITIONAL INFORMATION:
Login failed for user 'sqlapps'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

BUTTONS:
OK

Out of curiosity, can you login as sa?

No comments:

Post a Comment