Authentication modes to connect to SQL Server
SQL Server supports 2 types of authentication modes: SQL Server and Windows Authentication Mode.
The steps to change the SQL Server Authentication Mode.
We start by right clicking on the SQL Server instance and choose Properties from the pop-up menu, as shown in the below image.
Choose Security page in left pane of the dialog box. Now in the right side pane, in the top section (image below) you have the Server authentication section under that the 2 authentication modes are listed as an options, Choose the appropriate authentication mode you would like the SQL Server set to and click OK.
The next step is to restart the SQL Server.
Enable sa login using Management Studio
Authentication mode of a SQL Server instance decides how the SQL Server authenticates the users and logins.
The steps to change the SQL Server Authentication Mode.
We start by right clicking on the SQL Server instance and choose Properties from the pop-up menu, as shown in the below image.
Choose Security page in left pane of the dialog box. Now in the right side pane, in the top section (image below) you have the Server authentication section under that the 2 authentication modes are listed as an options, Choose the appropriate authentication mode you would like the SQL Server set to and click OK.
The next step is to restart the SQL Server.
Enable sa login using Management Studio
- In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
- On the General page, you may have to create and confirm a password for the sa login.
- On the Status page, in the Login section, click Enabled, and then click OK.