Configuring the Authentication Mode of SQL Server
Select whether to use SQL Server authentication or Windows authentication.
1.
Log on to the computer as a user with administrator privileges for SQL Server.
2.
Start SQL Server Management Studio and connect to the database engine (SQLEXPRESS).
NOTE |
If you cannot connect to the database engine because a TLS certificate error has occurred, one of the following measures is required. Change the server certificate (key) of the computer where SQL Server is installed to a trusted certificate (key) Install the certificate (public key) of the server to the client computer connected to SQL Server Trust the existing server certificate of the computer where SQL Server is installed |
3.
Right-click the database engine, and select [Properties].
4.
Select [Security].
5.
In [Server authentication], select the authentication mode.
When using Windows authentication
Select [Windows authentication mode].
When using SQL Server authentication
Select [SQL Server and Windows Authentication mode].
6.
Click [OK].
7.
Right-click the database engine, and select [Restart].