1

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 Dec 5 '13 at 1:11
0

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. – Shawn Melton Dec 5 '13 at 7:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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