Search

Monday, November 28, 2011

Not associated with a trusted SQL Server connection

When you're setting up a new MS-SQL connection, you might get the following error:
Not associated with a trusted SQL Server connection


What this means is that you have a logon that was defined in MSSQL - but you also have MSSQL set to only use Windows logon accounts.


To fix this, load up the SQL management tool. Expand out the SQL Server Group. When you click on SQL Server Group in the left window, it'll show an entry in the right window. Click on that and get its properties. Under "security", set authentication to allow SQL Server logins.

No comments:

Post a Comment