[SQL Quickies] “Login Failed for user” error in SQL Server

Here’s a quick tip on solving this problem on MS SQL Servers:

First of all, find why the problem exists:

• Right click “My Computer” and click Manager
• Expand Event Viewer
• Click on “Application”
• Look for “Failure Audit” in the logs. Your error might be different than mine, if it’s the same, keep reading.

SQL Server Error in Event Viewer

• If it looks the same, open your SQL Server Management Studio and login with your Windows authentication. Right click on the server name and click Properties

Sql Server Properties

• Go to Security tab and select SQL Server and Windows Authentication. Click Ok.

Sql Server Properties for Login Security

• Go to Start->Run. Enter services.msc and hit enter. Restart MS Sql Server Service from the list (Right click -> Stop -> Wait -> Start)
• Login with your desired user, your problem has been solved!

Enjoy,

Bora Bilgin