I have SQL Server 2005 SP3 running one server with mixed mode authentication. I tried to connect to the database engine, using the SQL Management Studio installed on the same machine. But I get a login error that says
Login failed for user *user*, (Microsoft SQL Sever, Error: 18456)
Strangely I'm able to connect to the Database through SQL Server Management Studio running on a different server. What am I doing wrong?