Shulou(Shulou.com)05/31 Report--

Sqlserver server verification to mixed verification mode what is the step, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

1. Start SQL Server Management Studio and log in as Windows authentication.

2. In the object Explorer window, right-click the server, select Properties, and open the Server Properties dialog box.

3. On the Security page, under Server Authentication, select the new server authentication mode, and then click OK.

4. Restart the SQL Server service, which can be started directly by clicking "object Explorer" on the right button.

5. Use this statement to enable sa user: alter login sa enable

6. Set the password of the sa user: alter login sa with password='your password'

Ok, now disconnect and use SQL Server authentication to try logging in as a sa user.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.