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:
BUTTONS:
OK
Out of curiosity, can you login as sa?
No comments:
Post a Comment