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.
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