SQL Server sa account does not log on the way

SA account is not logged on, it is always confusing. In fact, the key to the problem and the solution is as follows:

1, if a short period of continuous connection, will be mistaken for SQL Server is this is an attack, will be this account

Lock.

To log in using Windows, enter in the Query Analyzer:

ALTER LOGIN SA ENABLE;
GO
ALTER LOGIN sa with PASSWORD = ' unlock, Check_policy = off,

Check_expiration = off;
GO

2. This will leave the password blank, and then restart the login.

3. Open SQL Server Configuration Manager, expand SQL Server Network configuration, turn on TCP/IP in MSSQLSERVER protocol

4. Restart "SQL Server" service

This article from "Chest Technology blog" blog, declined reprint!

SQL Server sa account does not log on the method