Information
Uses Windows Authentication to validate attempted connections.
Windows provides a more robust authentication mechanism than SQL Server authentication.
Solution
Perform either the GUI or T-SQL method shown:
GUI Method
- Open SQL Server Management Studio
- Open the Object Explorer tab and connect to the target SQL Server instance.
- Right click the instance name and select Properties
- Select the Security page from the left menu.
- Set the Server authentication setting to Windows Authentication Mode
T-SQL Method
Run the following T-SQL in a Query Window:
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1
GO
Restart the SQL Server service for the change to take effect.
Impact:
Changing the login mode configuration requires a restart of the service.