How to Change the Windows Authentication Mode

Change the Windows Authentication Mode to a mixed mode utilizing SQL authentication.

The Windows Authentication mode is the method used by a computer to allow users to connect through a Windows account. The Windows Authentication mode provides secure validation and encryption of passwords. It can audit passwords for expiration and strength, and lock out users if someone else is attempting to access your computer without your knowledge. You can also change the authentication mode to a mixed mode from the registry. Mixed mode authentication enables both Windows Authentication and SQL Server Authentication.

Instructions

1. Open the registry. Click "Start" from the System Tray located at the bottom of
   the desktop. Click "Run" (Windows Vista and Windows 7) and
   type "regedit" in the search box. Press the "Enter" key. The Registry launches.

2. Navigate to the following registry key:

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

3. Double-click the "LoginMode" value in the right-hand pane. The DWORD Editor window appears. Enter "0" or "2" if you want mixed mode. The integrated mode is the default key for the SQL Server 2000 Data Engine.

4. Exit the Registry. Click "File" from the top menu and then click "Exit."

Tips & Warnings

• The registry contains all your operation and system files. Any adjustment, change, or deletion to the wrong registry key could cause your computer to become inoperable.

References

• Microsoft: How to Change the Default Login Authentication Mode