Log in to SQL server2008 using the set SA user

A small problem in the process of adding a database to the net project today is that the use of SQL Server Authentication has not been successful, and after some debugging, the problem is finally resolved.

To sign in to SQL Server 2008 using the SA account, follow these steps:

1. First turn on the computer, open SQL Server 2008, and use Windows authentication.

2. Successfully log in to SQL server2008, find security-login name, "sa" right click Select "Properties", first set the SA password, "Enforce password enforcement policy" tick.

3. Then select the Status property under the Properties page to allow the connection to the database engine to be set to authorize, and the login setting to Enabled.

4. After setting the above properties, select OK. Now go to set another important setting. Right-click the database engine, select Properties, select Security under the Properties page, select Server Authentication as SQL server and Windows Authentication mode, and click the OK button.

5. After the above steps are complete, now we look under, "sa" on the downward Red arrow number is still in, if the description is not set successfully. Because I have set up, so the "SA" account can be successfully landed.

6. After the above steps successfully set up, enter the password, click on the connection, you can successfully login system.

7. If you are still unable to log in, you can check to see if the service has been turned on, open SQL Server Configuration Manager

8. Click on the SQL Server network configuration to set the named Pipes and TCP/IP two protocols to start

9. Click the SQL Server service, restart SQL Server (SQLEXPRESS), and then open Management Studio using the sa login

Note: The above steps are set on SQL server2008, other SQL Server version databases are set up in a similar way

Log in to SQL server2008 using the set SA user