Category Archives: SQL Server

SQL server – The user is not associated with a trusted SQL Server Connection – Fixed

Issue:

The user is not associated with a trusted SQL Server Connection when the user is trying to login to SQL Server in management studio.

Solution
The reason of the issue is sql server authendication is disabled in your sql server. This can be enabled by the following steps

  1. Open Microsoft SQL server Management Studio Express
  2. Login in with Windows Authendication user
  3. Right click on the server name(Left pane) and click on properties
  4. Choose “Security” in the dialog windows(Left side)
  5. By default “Windows Authendication mode” is selected. You have to select “SQL Server and Windows Authendication mode” and click on “OK”
  6. Restart the sql server service and Login with the SQL Authendication user(Click here to Restart SQL  Services)