SQL Server cannot be started

SQL Server cannot be started

After the administrator password of the System user is changed, log out and log on again. the SQL Server is not started at random. Start the service manually from the Service Manager and prompt "the service cannot be started due to logon failure ".

Cause:

When installing SQL Server, the default logon user is used as the account for starting the SQL Server service (for standalone that you use, it is usually administrator ), when the user changes the user name (for example, changing the administrator name to admin) or the password, the user restarts the server again and the error "cannot start the service due to logon Failure" occurs.

SolutionAs follows:

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

2. Start SQLServer from the Database Service Manager;

3. Modify the administrator password from "Computer Management;

4. Open the Database Enterprise Manager, find the server to be modified in the database server list on the left, right-click the menu [properties], and select the "Security" Table item in the displayed Properties dialog box;

5. Change the password to the new password of administrator in the "Start Service Account" option and click "OK". The system prompts "do you want to stop and restart the server now? ", Click "yes ". The database server automatically stops and restarts.

Suggestions and summary:

1. If the option "Start Service Account" is not "this account" but "System Account", changing the user password will not cause database startup failure;

2. The database server must be in the running state before its attributes can be modified. Otherwise, the connection fails. Therefore, the database must be changed back to the original password and then modified after the database is started;

3. You must change the administrator password before modifying the Security Attribute of the database. Otherwise, the password cannot be modified.

Solution to SQL Server Agent failure

Data backup on servers is one of the most important tasks of network administrators in their daily work. The SQLServerAgent service allows us to use the SQL "Database Maintenance Plan" function to automatically back up data, however, I recently discovered that the SQLServerAgent service cannot be started on the server. In retrospect, I used to recall that I disabled the server access permission for the Builtin/Administrators account in SQL, the existence of this account is not safe for SQL, but does not want to delete it. Therefore, the permission of this account is forbidden. As a result, the SQLServerAgent service cannot be started.

SolutionSimply delete this account, create a user with both system management and SQL management permissions, and then use this user to start
You can use the SQLServerAgent service.

The procedure is as follows:

1. Open the Enterprise Manager, open the instance on the left-> Security-> log on, right-click the blank area on the right, select "New Logon", and click the button on the right of "name, many account names will appear. Select a user with windows super Administrator permissions (such as Administrator), click "add", and then select "System Administrators" in the "server role" tab, OK.

2. Open "manage" on the left of Enterprise Manager, right-click "SQLServer proxy", select Properties-> General-> Service Startup account, and select "this account ", then enter the account and password (for example :. /Administrator). The password is the password of this user. OK.

3. Finally, right-click "SQLServer proxy" and select "start". The Agent is successfully started.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.