I have my SQLServer 2005 instance configured for mixed mode fine. When using SSMS, none of the sql server logins seem to work. Just "Login failed for user '..'" message. But when I use SQLCMD, it works fine. The behavior is not just for one specific login account. All sql server logins including 'sa' fail when tried via SSMS. Windows logins work fine.

Any ideas?

  • Can you share the exact error message you're getting?
    – DBArgenis
    Commented Dec 5, 2013 at 1:11

1 Answer 1


Issue seems to be with the local SSMS install on the server. Everything works fine from odbc connections, remote SSMS connections etc.

  • If it is local, try forcing SSMS to use TCP instead of Shared Memory. You could also check to make sure someone didn't disable that protocol on the server.
    – user507
    Commented Dec 5, 2013 at 7:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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