Troubleshoot SQL Server versions of the SA account cannot log on _mssql

1. Using management Studio Express, log in with Windows authentication, select the SQL Server name, right-click the mouse to select Properties, and in the Server Properties Options page, select Security to change server authentication from Windows authentication to SQL Server and Windows authentication, click OK.

2. Using the SQL Server 2005 perimeter configuration, select the perimeter configuration for services and connections, choose the SQL Express–>database engine–> service, stop, restart, and reboot the SQL Server server.

3. Go back to management Studio Express, select the "Security" –> login –>sa, right-click the mouse, in the Login Properties-sa page, select the status, change the login from "Disable" to "Enable" (at this point you can set the sa login password or cancel the login password, In the General Options), click OK.

Specific actions:

1. Log in with Windows authentication first

2. Whether to allow connection to the database engine-Grant login-Enable