Microsoft KB Archive/285097

= How to change the default login authentication mode to SQL while installing SQL Server 2000 Desktop Engine by using Windows Installer =

Article ID: 285097

Article Last Modified on 1/11/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)

-



This article was previously published under Q285097



Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SUMMARY
When using SQL Server 2000 Desktop Engine Windows Installer Merge Modules, an option named SECURITYMODE can be used to change the default login authentication mode from Windows NT authentication to SQL authentication.



MORE INFORMATION
The authentication mode can also be changed at the time of the installation by using the following command-line setup parameter for SQL Server 2000 Desktop Engine: SECURITYMODE=SQL For more information, refer to the &quot;3.1.4 Desktop Engine Setup Parameters&quot; section in the Readme.txt file for SQL Server 2000 Desktop Engine installation.

By default, SQL Server 2000 installation sets the login authentication to Windows authentication mode. This can be easily changed after the install by connecting to the server by using any installation of SQL Server Enterprise Manager (SEM). For more information regarding changing authentication mode by using SEM, refer to the &quot;Authentication&quot; topic in SQL Server Books On-Line.

Another way to change the security mode after installation is to stop SQL Server and set the appropriate registry key for your installation:

Default instance:

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

Named instance:

HKLM\Software\Microsoft\Microsoft SQL Server\ \MSSQLServer\LoginMode

to 0 or 2 for mixed-mode or 1 for integrated. (Integrated is the default setup for the SQL Server 2000 Data Engine.)

Note The 0 and 2 values have the same functionality. They both set the security to mixed-mode.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To set this key to mixed-mode, follow these steps:  Stop SQL Server and all related services, such as SQLAgent, from the Services control panel. Click Start, click Run, type regedt32, and then click OK. Find the HKEY_LOCAL_MACHINE window on the local computer. Navigate to the following registry key for the default instance:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer

 Navigate to the following registry key for a named instance:

HKLM\Software\Microsoft\Microsoft SQL Server\ \MSSQLServer\LoginMode

 On the right-hand pane, find the value LoginMode and double-click it.</li> In the DWORD Editor window, set the value to 0 or 2. Also, make sure that the Hex radio button is selected.</li> Click OK.</li></ol>

Restart SQL Server and SQL Server Agent services for this change to take effect.

Note When you change the default login authentication mode from Windows NT authentication to SQL authentication, we recommend that you change the sa password to a strong password.

For more information about how to change the SQL Server sa password, click the following article number to view the article in the Microsoft Knowledge Base:

322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition