Login Failed using SQL Server Authentication and Windows Authentication??
Posted on 2008-10-23
I have just installed SQL Server 2005 Evaluation on a Windows Vista Home Premium PC. I downloaded the application and Service Packs for SQL Server 2005 and Visual Studio 2005. I would like to have SQL Server configured with the Mixed Mode for login (Windows and SQL Server Authentication).
When ever I try to login using either modes, I get the following error ...
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Is there a way correct this error and possible set/reset/check the login modes.