:::: MENU ::::

LogIn failed for user. The user is not associated with a trusted SQL Server connection.

  • Jan 24 / 2009
  • 0
dbDigger, Logins and Users, Security and Permissions, SSMS tips and tricks

LogIn failed for user. The user is not associated with a trusted SQL Server connection.

While logging in to your SQL Server instance through SSMS/EM/QA, you may get following error message.
LogIn failed for user ”. The user is not associated with a trusted SQL Server connection.

LogIn Failed For User

In this case you have to change the authentication mode of your that SQL Server instance. Basically SQL Server can authenticate in two modes.

  • Windows authentication mode
  • Mixed mode authentication

If your instance is set to windows authentication mode then while trying to log in through SQL Server user, you will get above error message.
To remove the error and get log in through SQL Server ID, simply change the authentication mode of your SQL Server instance to mixed mode. Follow the following steps for it in SSMS.

Right click on your SQL Server instance and click properties

Go To Properties of Server Instance

A frame will appear with two authentication modes options on it. Change authentication mode to SQL Server and Windows Authentication mode (mixed mode) and click OK.

Set Mixed Mode Security

SQL Server instance restart will be suggested to implement the changes fully.

Configuration Change Confirmation

Restart your SQL Server instance by right clicking it and selecting restart menu item.

Restart SQL Server Instance Service

Now you can log in to this instance successfully. I logged in through SQL Server account id ‘test’.

Connected Through SQL Server Authentication

Consult us to explore the Databases. Contact us