After you install SQL Server 2012, the Windows authentication is set to mixed-type authentication

Source: Internet
Author: User

How to resolve Sql2012windows Authentication mode to mixed authentication mode ...

Because SQL Server uses Windows only authentication, users cannot connect using SQL Server's logon account, such as SA. Workaround:

1. Select "Use Windows Authentication" to connect to SQL Server;

2. Expand SQL Server Group, right-click the name of the SQL Server server (the Blue section), right-click, and select Properties.

3. Select the "Security" tab and select "SQL Server and Windows Authentication mode".


4. Set the password for the "sa" login, for example, select "SA", right-click, and select "Properties".


5. The SQL Server Login Properties dialog box pops up, as shown in 4. In the "SQL Server Authentication" password bar, enter the latest password. Click the OK button to pop up the Confirm Password dialog box and lose the login password again.


6. Make sure the login is enabled status.

7. Restart the SQL Server service.

Services, management tools, Control Panel, locate the following services, and then restart.

Or, open the SQL Server Configuration tool (All Programs->sql Server 2012-> Configuration Tool->sql Server Configuration Manager), as shown in, select the Blue area, right-click, restart.

Resources:
http://blog.csdn.net/johnson_hejun/article/details/3090028

http://blog.csdn.net/johnson_hejun/article/details/3090076

After you install SQL Server 2012, the Windows authentication is set to mixed-type authentication

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.