SQL Server error message Login failed for user ''. The user is not associated with a trusted SQL Server connection. when trying to connect to database using SQL Server Authentication.
- Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
- Right-click the Server name, select Properties > Security
- Under Server Authentication, select SQL Server and Windows Authentication Mode
- The server must be stopped and re-started for this change to take effect