How to set "Mixed Mode Authentication" without SQL Management Studio

The Authentication mode for MS-SQL Server can be changed after installation without installing the SQL Management Studio.
  1. Open the Window Registry Editor (Start --> Run --> regedit.exe).
  2. Go to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\MSSQLServer where <INSTANCE NAME? is the name of the MS-SQL instance.
  3. Locate the field "LoginMode". Change it's value to "2" to put MS-SQL into Mixed Mode Authentication.
  4. Restart the MS-SQL service.
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. Use Registry Editor at your own risk. You should back up the registry before making any changes to it.

To backup a selected key in the registry, use these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type regedit.exe, and then click OK
  3. Locate and then click the key that contains the value that you want to edit
  4. Right-click on the key and choose Export.
  5. In the Save in box, select a location where you want to save the Registration Entries (.reg)
  6. In the File name box, type a file name, and then click Save.
How did we do with this article?