Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Can you share the exact error message you're getting? – DBArgenis Dec 5 '13 at 1:11
up vote 0 down vote accepted

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

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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