SQL drip 11-Reset win7 login password affects SQL Login

Source: Internet
Author: User

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:

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.