Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.
Published February 26th, 2007 in General, SQL ServerShortly after setting up a new SQL server I often find myself getting this message and well I google and find out what the problem is and fix. Well I figured I’m going to start posting more of these “duh” troubleshooting problems on my blog. That way I can still forget them, google the problem, and then read the answer on my blog.
Anyway if you get this error it pretty much means that when you were setting up SQL Server you went with all the defaults, which means SQL Authentication is not enabled and you can only connect to the server via Windows Authentication.
To fix simply
- connect to the server via windows authentication in SQL Server Management Studio.
- Right click on the server you want to configure and select ‘Properties’
- Then click on the security section
- Then in the first topic ‘Server authentication’ - select to the radio box for ‘SQL Server and Windows authentication mode’
- Click OK
- Restart the SQL Service and get back to work
*Note this was for SQL Server 2005 and SQL Server management studio, but it should be very similar if not identical in SQL Server 2000 and Enterprise Manager.