Sean Feeney
Architect of the digital age

Determine Authentication Mode for MSSQL

17 February 2011

Check the LoginMode registry key. The path for this key for each version can be found below.

If the value is 1, it's Windows Authentication. If the value is 2, it's Mixed Mode Authentication.

For 2000: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server’ + @sqlpath + ‘MSSQLServer

For 2005: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer

For 2008: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLServer

Posted in Microsoft, mssql

You agree to my disclaimer, regardless of the decision in Nguyen v. B&N.

Social

Causes

Genealogy


I Love Geni