SQL Server solution for connecting to server error 233 _mssql2005

My SQL Server2005 has been working normally but yesterday was an error, as shown in figure.

After the internet search, said the way to try a lot of the internet has not solved this problem. After many groping finally finished, the answer is very simple, is the SQL Authentication "SA" account login password problem.

But the premise is that you have to make sure your SQL Server SQL authentication is available, so here's how you can make SQL authentication enabled (SQL Server authentication can be used to skip this step directly).

Windows authentication is not allowed to log on first, please see my previous blog, "Resolve SQL Server connection Server error 2" To set, here is no longer said.

Then right-click the property on the server, go to the property page, and set the server authentication in security.

Next, right-click the attribute on the login name "sa" under Security and set the password

Here our SQL authentication is ready to use.

After SQL authentication is available, we reset the "sa" password, and your SQL Server's SQL identity can be used, and the answer is simply to reset the password.