Archive for the ‘SQL Server’ Category

System.Data.SqlClient.SqlException: Login failed for user

Saturday, August 30th, 2008

I’ve had this exception happen to me so many times in the past but I’m always forgetting what the solution is. It ends up I keep forgetting to have "SQL Server and Windows Authentication mode" selected in the properties window for the database server.

serverproperties