Changing the MSSQL Login Mode

Below are some tips on how to change the MSSQL login mode. Note that this *may* break your application, so testing must first be performed.

Via the registry:

1) Stop the MSSQL service (either execute a 'NET STOP MSSQLSERVER' at a DOS Prompt or open the Services Control Panel and stop the MSSQLSERVER service)

2) Open up the Registry Editor (regedit.exe)

3) Navigate to the My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode Key

4) Change the LoginMode value to '1' ('0' or '2' means it will use either Windows or built-in authentication)

5) Restart the MSSQL server (reboot, issue a 'NET START MSSQLSERVER' at a DOS Prompt or open the Services Control Panel and start the MSSQL service).

Via the Enterprise Manager GUI (installed from the MSSQL Server CD)

1) Open the Enterprise Manager
Start Menu\Program Files\Microsoft SQL Server\Enterprise Manager

2) Right click on the SQL server instance and select the Properties:

3) Select the Security Tab and select the Windows Only radio button

4) Restart the MSSQL server.

For assistance contact helpdesk@fnal.gov.
Information compiled and maintained by Computer Security Team ; last modified by TR on July 13, 2006.
(Address comments about page to the Computer Security Team.)