Troubleshoot SQL Server connection to server error 223

My SQL Server2005 has been working normally but yesterday there was an error.

After internet search, online said the method tried a lot of did not solve the problem. After a lot of groping and finally fix, the answer is very simple, is the SQL Authentication "SA" account login password problem.

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

First sign in with Windows Authentication, Windows authentication can not be logged in please see my previous blog "Resolve SQL Server connection Server error 2" in the settings, here will not say more.

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

Next, under Security login name "sa" right click on the properties, password settings

Here, our SQL authentication is ready to use.

After SQL authentication can be used, we re-set the "SA" password, and your SQL Server's SQL identity can be used, the answer is that simple, re-set the password.