We all know that SQL Server has two types of logon authentication, SQL Server authentication and Windows authentication, but SQL Server defaults to how Windows logon authentication works, how do we enable SQL How does the server and Windows hybrid validate and log in successfully? The following will be announced.
steps to readTools/Materials
Steps/Methods
- 1
Open and log on to SQL Server 2008 with the default Windows authentication, log on to \ Security \ Logins, select the user to use SQL Server login authentication (for example, SA), right-click the SA, and select Properties.
steps to read steps to read
- 2
After opening the Properties window, navigate to the General tab, modify the password and tick or uncheck the checkbox option.
Steps to read
- 3
Then switch to the "Status" tab, select "Connect to Database" to "grant", "Sign in" to "Enable", then click on the "OK" button at the bottom right to save the exit.
Steps to read
- 4
Right-click the logged on user connected to the database, select the "Properties" option in the right-click menu that appears, and the interface shown in the second image appears.
steps to read steps to read
- 5
Switch to the Security tab, under Server Authentication mode, select SQL Server and Windows authentication modes, and click OK to save the exit.
Steps to read
- 6
Right-click the logged-on user connecting to the database, select the "Stop" option in the right-click menu that appears, stop the server process, and select "Yes" in the prompt form that appears.
steps to read steps to read
- 7
When the SQL Server server icon turns yellow, still right-click it, tap Start, and in the prompt form that appears, select Yes.
steps to read steps to read
- 8
When you close Microsoft SQL Server and log on as an SA user again, you can successfully log on to SQL Server by using SQL Server login authentication.
steps to read steps to read END
Precautions