SQL Server 2008 Login failed with ' sa ' to enable ' sa ' login solution _mssql2008

Problem: SQL Server 2008 Login failed with ' sa ', enable ' sa ' login method

First "Why not login with SA, prompt login failed?" "

Of course, when I installed SQL Server 2008, there was no way to log in with the SA, and when I installed the database, I logged in as a Windows user.

If you want to enable the user name "sa" and SQL Server authentication, should you be able to resolve the problem by following these steps? I'm not sure I can, but it's usually the way to solve it.

1. First log in as a Windows user, with the following interface

2. Right key instance--> property, select "Security", select authentication method

3. Right key instance--> "reboot"

4. Select "Security"--> "login name"--> "sa"

5. Double click "SA", the following view appears, click "General", set a new password

6. Select "Status" and modify it to the following settings

7. "File"--> "Connection Object Explorer", open the Authentication interface, select "SQL Server Authentication", and fill in the appropriate username and password.

8. Launch "SA" successful!!!

These are the solutions to SQL Server 2008 failure to login with ' sa ' and hope to solve the real problem.