How to change Windows Authentication Mode to Hybrid Authentication Mode

Source: Internet
Author: User
Tags builtin
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;
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.