Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the problem that the SQL server can not be started, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Reason:

When SQL Server is installed, the default login user is used as the account to start the SQL Server service (for the stand-alone machine he uses, it is usually administrator). When the user changes the user name (such as changing administrator to admin) or his password, and starts the server again, there will be an error of "the same as login failure and unable to start the service".

The solution is as follows:

1. Change the administrator password back to the original password.

2. Start SQLServer from the database service manager

3. Change the password of administrator from "computer Management"

4. Open the database enterprise manager, find the server you want to modify in the list of database servers on the left, right-click the menu [Properties], and select the "Security" table item in the properties dialog box that appears.

5. Change the new password to administrator in the "this account" option at "start Service account", click "OK", and the system prompts "do you want to stop and restart the server now?" Click "Yes". The database server automatically stops and restarts.

Suggestions and summaries:

1. If the option at "start Service account" is not "this account" but "system account", changing the user's password will not cause the database to fail to start.

2. The database server must be in a running state before its properties can be modified, otherwise the connection cannot be made. Therefore, it is necessary to change the original password back to the original password and modify the database after startup.

3. The password of administrator must be changed first, and then the security properties of the database must be modified. Otherwise, it cannot be modified.

The solution to the failure to start SQLserverAgent on the SQL server

Backing up the data on the server is one of the most important tasks in the daily work of the network administrator. The SQLServerAgent service enables us to automatically back up the data using the "database maintenance plan" function on SQL, but recently I found that the SQLServerAgent service on the server could not be started. When I recall what I have done recently, it is because I have disabled the server access of the Builtin/Administrators account in SQL. Because the existence of this account is not secure for SQL, but does not want to delete, so its permissions are prohibited, as a result, the SQLServerAgent service cannot be started.

The solution is simple: delete the account, create a user with both system and SQL administrative privileges, and then use this user to start the SQLServerAgent service.

Here are the steps:

1, open the enterprise manager, open the instance on the left-> Security-> Login, right-click in the space on the right, select "New login", click the "name:" button on the right, many account names will appear, select a user with windows Super Admin privileges (such as Administrator), click "add", and then select "System Administrators" in the "server role" tab to check the tick.

2, open the "Administration" on the left side of the enterprise manager, right-click "SQLServer Agent", select Properties-> General-> Service start account, select "this account", and then enter the account and password you just created (for example:. / Administrator), the password is the password of this user, OK.

3. Finally, right-click "SQLServer Agent" and select "start" to see that Agent has started successfully.

On the SQL server can not start how to share here, I hope that the above content can be of some help to you, can 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.