How to change Windows Authentication Mode to Hybrid Authentication Mode

1. How Solution SQL 2000 connection Database Failed and how to identify windowsVerify Mode To the mixed Verification Mode...
Because SQL Server Only Windows authentication is used. ThereforeUser You cannot connect to an SQL Server Logon account (such as SA. The solution is as follows:
1. Server Use the Enterprise Manager and select "use Windows Authentication" to connect to SQL Server;
2. Expand "SQL Server group", right-click the name of the SQL Server server, and select"Attribute ", And then select the" Security "tab;
3. Under "authentication", select "SQL Server and Windows ".
4. Restart the SQL Server service.
In the above solution, if you fail to connect to SQL server by using "use Windows Authentication" in step 1, we will encounter a dilemma: first, the server only supports Windows authentication. Second, even if Windows authentication is used, the server cannot be connected. This situation is vividly referred to as "locking yourself out of the door", because no matter what method is used, users cannot use the connection. In fact, we can modifyRegister To change the authentication method to SQL Server and Windows Hybrid Authentication, follow these steps:
1. Click "start"-"run", enter regedit, and press enter to enter the Registry Editor;
2. Expand the registry key in sequence and browse to the following registry key:
[HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQL Server \ MSSQLServer]
3. Find the name "loginmode" on the right of the screen and double-click to edit the double-byte value;
4. Change the original value from 1 to 2 and click "OK ";
5. Close the Registry Editor;
6. Restart the SQL Server service.
In this case, you can successfully use SA to create an SQL Server registration in the Enterprise Manager, but you still cannot connect to SQL Server in Windows Authentication mode. This is because there are two default logon accounts in SQL Server: builtin \ administrators and <machine Name> \ Administrator Delete . To restore these two accounts, you can use the following methods:
1. Open the Enterprise Manager, expand the server group, and then expand the server;
2. Expand security, right-click logon, and click New logon ";
3. In the Name box, enter builtin \ administrators;
4. On the "server role" tab, select "System Administrators ";
5. Click "OK" to exit;