Setting SQL Server to use Mixed Mode/SQL Authentication
![]() |
![]() |
Description
If during SQL Server installation it was chosen to only use Windows Authentication instead of Mixed Mode Authentication, many products will be unable to connect to SQL Server.
Author |
Dillon Perera |
Publish Date | 6/12/2014 |
Applies to Software |
SQL Server |
Applies to Version |
2005 and higher |
Applies to System/Module |
|
Article Version |
|
************************************************************************************************************************************************************
Detailed Steps
- Open SQL Server Management Studio by going to Start > Programs > Microsoft SQL Server YEAR > SQL Server Management Studio.
- Log in with Windows Authentication with an administrative account.
- Change the authentication
- On the Object Explorer window right click on the server name and go to Properties.
- Select the Security section.
- Under Server Authentication change the selection from Windows Authentication mode to SQL Server and Windows Authentication mode.
- Click Ok
- Click Ok
- Select the Security section.
- On the Object Explorer window right click on the server name and go to Properties.
- Enable the sa login:
- In Object Explorer expand the Security folder, and the Logins.
- Right click sa and go to Properties.
- On the General tab set the password you want to use.
- On the Status tab, in Login set it to Enabled.
- Click OK
- Restart SQL Server:
- Right click on your Server name in Object Explorer
- Select Restart