I am not able to login to SQL Server with the SQL authentication. What should i do?

Enabling SQL Server Authentication through SQL Management Studio

  1. Open SQL Server Management Studio.
  2. Choose Windows Authentication from the Authentication drop down list.
  3. Click on Connect tab to open the Microsoft SQL Server Management Studio Express window.
  4. Right-click the SQL instance and choose Properties to open the Server Properties - window.
  5. Click on the Security tab on the left-hand side.
  6. Choose SQL Server and Windows Authentication Mode on the right side.
  7. Click on OK to close the Server Properties - window.
  8. Right-click the SQL instance and choose Restart.
  9. Click on Yes tab to restart the SQL server.

Ask a question

"Hey couldn't find what you were looking for in our knowledgebase? Please enter your question here".

First Name *
Last Name *
Email Address *
Question *
Captcha *