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.
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
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.
SQL Server instance restart will be suggested to implement the changes fully.
Restart your SQL Server instance by right clicking it and selecting restart menu item.
Now you can log in to this instance successfully. I logged in through SQL Server account id ‘test’.