SQL Drip 11-Reset win7 login password affects SQL login

Original: SQL Drip 11-Reset win7 login password affects SQL login

2011-04-20 you cannot log on to SQL Server after you modify the machine login password

Find a very interesting phenomenon today. The company's computer every two months will be prompted to reset the login password, today I changed the password to log in to find that I can not log into SQL Server, I am the 2008 version. This is odd a strange, before also changed several times password, ah, this is how to die. Later, at the prompt of the old employee, it was necessary to reset the password for all the service of SQL Server.

Open the service, right-click SQL Server (SQLEXPRESS), click the Log On tab, and change the password. Then log in again and this will be all right. If there are other SQL Server objects that cannot log on, modify the corresponding service.

　　

2011-9-1 sa account cannot be logged in

Today, colleagues encountered a problem, he installed the database, Windows authentication can be correctly logged in, but if the use of the SA account will not log on, the error is: Login failed for user "error:18456. Again to re-establish a login user, still cannot log in. Find a place to go on the Internet.

The preferred entire server has a property, right-click on the server name, typically displayed as the computer name, select Properties, select the Server Authorization tab bar in the Popup dialog box, select SQL Server and Windows Authorization Select items. Such as:

　　

There is also a place where the login properties of the SA account need to be set up. Enter the server security,logins, select the sa account right click on Properties, enter the login properties interface, set Prmission to connect to database The engine property and the Login property are grant,enable options, respectively, such as:

SQL Drip 11-Reset win7 login password affects SQL login