Turn on Mixed Mode Authentication After You Install MSDE
WARNING: If you modify the registry incorrectly, serious problems may occur that require you to reinstall your operating system. Microsoft cannot guarantee that the problems can be solved. Modify the registry at your own risk.
Microsoft recommends that you back up the registry before you modify it. If you are running Microsoft Windows NT or Microsoft Windows 2000, also update your Emergency Repair Disk (ERD).
By default, the value of the LoginMode Windows registry subkey is set to 1 for Windows Authentication. To turn on Mixed Mode authentication after you install MSDE, you must change this value to 2. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance.
a.. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode
To change the value of LoginMode to 2, follow these steps:
1.. In Control Panel, open the Services tool, and then stop MSSQLSERVER and all other related services (such as SQLSERVERAgent).
2.. On the Start menu, click Run, type regedt32, and then click OK to start Registry Editor.
3.. Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance):
b.. HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\
4.. In the right pane, double-click the LoginMode subkey.
5.. In the DWORD Editor dialog box, set the value of this subkey to 2, verify that the Hex option is selected, and then click OK.
6.. Restart the MSSQLSERVER service and the SQLSERVERAgent service for this change to take effect.
A registry-t matató xp-k: