SQL Server 2005: Error: 18452 Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.

This error occurs when you attempt to login to SQL Server using SQL Server Authentication mode (username + password) when the SQL Server instance is only configured for Windows Authentication.

To fix the issue:

  1. Enable SQL Server Authentication
  2. Enable the “sa” user, and configure a password for it
  3. Restart the SQL Server Instance

Continue reading SQL Server 2005: Error: 18452 Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.