Article ID: 285097
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.
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:
For more information, refer to the "3.1.4 Desktop Engine Setup Parameters" 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 "Authentication" 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:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\LoginModeto 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.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
To set this key to mixed-mode, follow these steps:
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:
(http://support.microsoft.com/kb/322336/ )How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition
REFERENCESFor more information about using Windows Installer if you are customizing set up for SQL Server 2000 Desktop Engine, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/227091/ )Command-line switches for the Windows Installer Tool
(http://support.microsoft.com/kb/280352/ )How to install SQL Server CE from the command line and generate a log file
Article ID: 285097 - Last Review: June 19, 2014 - Revision: 4.0