Launch the Microsoft SQL Server Management Studio (or type ssms from Windows search). Connect and right click on the SQL server instance. Select Properties.
This will display the Server Properties. Go to Security page and under server authentication, you can select Windows Authentication mode or SQL Server and Windows Authentication mode. Click OK to save and restart the SQL service to activate the changes.
Alternatively, you can use Windows Registry Editor to perform the same change. Navigate to the following directory, (depending on your SQL version, in our case, it’s MSSQL11 which means SQL Server 2012). Refer to sqlserverbuilds.blogspot.com to obtain the server build and revision.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQLServer
On the right panel, double click on LoginMode and you may change the value as per below options,
- 1 = Windows Authentication mode
- 2 = SQL Server and Windows Authentication mode
