SQL drip 11-Reset win7 login password affects SQL Login

After changing the machine logon password, you cannot log on to SQL Server

Today I found a very interesting phenomenon. The company's computer will prompt you to reset the logon password every two months. Today, I changed the password to log in and found that I cannot log on to SQL Server. My version is 2008. This is a strange thing. I used to change my password several times. How can this problem be solved. Later, at the prompt of the old employee, it was necessary to reset the passwords of all SQL Server services ..

Open service, right-click SQL Server (sqlexpress), click the log on tab, and change the password. And then log on again. This is the right time. If other SQL Server objects cannot be logged on, modify the corresponding service.

2011-9-1 SA account cannot log on

Today, my colleague encountered a problem. After the database is installed, Windows authentication can be used to log on correctly, but the SA account cannot log on. The error message is: Login Failed for user ''error: 18456. A New Login User is created and cannot log on again. Find the relevant information on the Internet.

First, the entire server has an attribute. Right-click the server name. Generally, the computer name is displayed. Select properties. In the displayed dialog box, select the server authorization tab, select SQL Server and Windows authorization. For example:

In addition, you need to set the login properties of the SA account. Choose security and logins on the server, select the SA account, and right-click Properties to go To the login properties interface. Set the prmission to connect to database engine attribute and the login attribute to grant and enable options respectively, for example: