Thank you for your feedback.

Was this useful?

Change authentication mode from Windows Registry

Article ID
ias-12300
Article Name
Change authentication mode from Windows Registry
Created Date
28th July 2016
Product
Problem
Cannot change the SQL authentication to mixed mode because SQL Studio is not installed.
Resolution
The SQL Server authentication mode can be changed via the Windows Registry. Here is how. • Open the Registry Editor ( run –> regedit.exe) • If the version is SQL Server 2008, navigate toHKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQL10.InstanceNameMSSQLServer • If the version is SQL Server 2012, navigate toHKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQL11.InstanceNameMSSQLServer • Double click to open the DWORD value named LoginMode • Enter the value as 2 for SQL Server and Windows Authentication (Mixed) mode or 1 forWindows Authentication mode. • Click Ok and exit the registry editor Now the SQL Server Instance is using the mixed mode as edited in the Windows Registry.

Thank you for your feedback.

Was this useful?