SQL Server Login attempts fail when using SSMS but succeed when using SQLCMD 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?
Issue seems to be with the local SSMS install on the server. Everything works fine from odbc connections, remote SSMS connections etc.