Shulou(Shulou.com)06/01 Report--

This article introduces the processing method that SQL can not start normally after updating the administrator password, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Because the domain is added to the computer, the domain policy is set to automatically update the local administrator password. After logging in to the computer with a domain user who is not an administrator, you will find that SQL cannot start normally. The prompts are as follows:

Because this is a bird language version of the system, so if you do not understand, you can directly find du Niang. The message above is that the service login failed.

There are two main reasons for login failure:

1. The login password of the local administrator is incorrect.

2. The dependent service of SQL does not start normally.

Once we know the cause of the error, we just need to follow the above step by step to OK.

Update the login password first > if you have the login password of the local administrator, enter the OK directly below. If you don't have it, you need to use the administrator (domain) to change the password of the local administrator.

Change the local administrator password as shown below: (if you already have a password, please skip it directly)

Change the login password on SQLserveragent:

Note:

1. If you choose the first one, the logged-in user must have local administrator privileges (the advantage is that there will be no problem the next time you update the local administrator password)

2. If I choose the second one, the next time I update the local administrator password, I still have to restart the configuration here, but the user in the login interface may not be an administrator.

After the input is completed, click to start it directly. If it is normal, OK. If it is still not normal, you should see if its dependent service is turned on. This is the problem I encountered. The dependent service has not been opened, and I have been confused all the time. It still prompts login failure.

The main reason is: the dependent service also needs to log in with the administrator password, so after changing the local administrator password, remember to update it at the dependent service.

Check the dependent service first:

When you see the dependent service, look for the MSSQL option directly in the service options. As shown below:

Re-enter the correct user name and password here and click OK.

Start it directly, then go back to the SQLSERVERAGNET service, click start, and it's done.

The processing method that SQL can not start normally after updating the administrator password is shared here. I hope the above content can be helpful to everyone and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.