Change authentication mode from Windows Registry

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.