Skip to main content
InSource Solutions

TN WW135 SQL: Enable mixed-mode authentication and create sa password.

insource logo large.jpg

 

Description

How to enable mixed-mode authentication and setup SQL sa account.

 

  • Author: Ernest Lee
  • Published: 11/25/2015
  • Applies to: SQL 2008 and higher

 

 

Details

Login to SQL using Windows authentication and then expand Security -> Logins.

Double-click sa and then click Status on the left. Make sure Grant and Enabled are selected.

 

pic1.jpg

 

Next click General on the left and set the password for the sa account. Do not check any of the boxes.

pic2.jpg

 

Next click on the SQL server which will be at the top of the list on the left.

Right-click and choose properties. We need to enable mixed-mode authentication.

Click Security on the left and choose SQL Server and Windows Authentication mode.

pic3.jpg

 

After clicking OK, right-click on the SQL server again and choose Restart.

pic4.jpg

 

Once the restart completes, close and re-open SQL and at the login screen change Authentication to SQL Server Authentication and login with the sa username and password you created.

pic5.jpg

 

If you are using DB Logger Manager you will need to access Settings and then edit the sa password to match that of SQL.