The SQL database server could not start

You go to the service manager to see if any service is being shut down. Control Panel - Management Tools - Computer Management Panel, there is a service and application in it, open the service panel, you can see the startup status of the series of services on the right, mainly whether the mssqlsever service is started, and then you try to modify the startup state.

Is your mssqlsever service status automatic, manual, or disabled? If it's disabled, change it to automatic or manual first, and then restart it, if it's not disabled, it seems that your SQL is restricted by some software, or it's poisoned. That's just a reinstall and a try.

Be more specific. For example, whether the database is complete, or restart the computer to see if it is complete.

Cause: The sqlserver service is not set to start.

1. First turn on the computer, right-click on my computer and select "Manage".

2. Then click on the "Service" option in the service and application in the pop-up window.

3. Then find "sqlserver (mssqlserver)" in the pop-up window.

4. Then right-click and select "Start" to finish.

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

2. Start sqlserver from the database service manager;

3. Change the password of the administrator from "Computer Management";

4. Open the database enterprise manager, find the server you want to modify in the database server list on the left, and click the right-click menu

Properties], select the Security table entry in the properties dialog box that appears;

5. Change the password to the new password of the administrator in the "This Account" option in the "Start Service Account" section, and click "OK". , "Do you want to stop and restart the server now?" ", click "Yes". The database server is automatically stopped and restarted.

The SQL Server service in the SQL Server 2008 service cannot be started.

1. Change the password of the administrator back to the original password; 2. Start sqlserver from the database service manager; 3. Change the password of the administrator from "Computer Management"; 4. Open the database enterprise manager, find the server you want to modify in the database server list on the left, click the right-click menu [Properties], and select the "Security" table item in the properties dialog box that appears; 5. Change the password to the new password of the administrator in the "This Account" option in the "Start Service Account", click "OK", and the system prompts "Do you want to stop and restart the server now?" ", click "Yes". The database server is automatically stopped and restarted.

One. SQL Server Service Remote Procedure Call Failure Resolved: Upgrade SQLSer2008R2 to SP1 or SP2. If it doesn't start, try something like this:

Right-click "Computer" "Management" "Services", find SQL Server (MSSQLSechServer), right-click, and select "Start". Log in to the database again, no problem. Two.

The service cannot be started due to a problem with the VIA protocol. Check the system logs, and then use the log file viewer built with sqlserver to view the sqlserver logs, and the error message is as follows: It can be seen that there is a problem with the VIA protocol of SQL server.

Go to SQL Server Configure Manager, click SQL Server Network Configuration (non-SQL Native Client configuration), click SQLSer2008 (my SQLSer name) protocol, and disable the VIA protocol. Start the SQL Server service again, and it is successful.

Bring up the run menu and enter enterFind the SQL Server (MSSQLSer) service and set the login identity to the local system account. Click on the SQL Server service on the left, you can see the SQL Server (MSSQLServ) service in the right window, the service is in a stopped state, double click to open, detailed steps:

Tools Raw Materials:

PC: ThinkPad E425

System: win7 ultimate.

Database: SQL Server 2005

1. Press Win+R shortcut key combination to bring up the run menu, and then enter enter.

2. In the pop-up menu, find the SQL Server (MSSQLSmart) service or the service corresponding to the instance you set up in the name window on the right.

3. Then double-click the service, and click the login tab in the pop-up properties interface.

4. In the login tab, set the login identity as the local system account.

5. After the settings are completed, click Start, Program, find the configuration tool under Microsoft SQL Server 2005, SQL Server Configuration Manager, and click Open.

6. After opening, click SQL Server Service on the left, and you can see SQL Server (MSSQLSer) Service in the right window.

7. When you see that the service is stopped, double-click to open it, in the login tab, set the login identity to the built-in account local system, and click OK after setting.

8. Then right-click SQL Server (MSSQLSer) and select Start, which is being started at this time, and wait for the startup to be completed.

1. Open "Services", find the SQL Server (MSSQLSmart) service (or the service corresponding to the set instance), check the properties, and select "Local System Account" in the "Login" tab.

2. To be on the safe side, do this: open SQL Server Configuration Manager and find the corresponding instance in SQL Server Service (the name is the same as the name in "Service"). In the "Login" tab, select "Built-in account" and select "local system" (all other things like network service are fine, but make sure you have permissions).

3. Start the SQL Server (MSSQLSserver) service.

4. If there is still an error (such as error 126), go to the installation directory of SQL Server, assign the network service and the permissions of the current logged-in user to the entire installation directory, especially the directory where the instance is located, and the directory related to the database file, and assign the write permission. Start the service again when you're done.

Incorrect address configuration: Open SQL Server Configuration Manager under Microsoft SQL Server 2005 Configuration Tool, select MSSQLSckerer protocol, and double-click on the right window.

2.It may be caused by the VIA protocol enabled. Here's how to solve it: Open SQL Server, the configuration tool in SQL Server 2008

3.If the administrator password is changed, the SqlServer service will not start.

Question: I'm an XP system.

2. Try to start the sqlserver service through the service in the operating system:

1) Right-click on "My Computer" and select the "Manage" menu.

2) In the Computer Management program, go to Services & Applications - > Services.

3) In the service list, select "mssqlserver", right-click, and select "Properties" menu.

4) In the Properties dialog box, switch to the Login page. Select the "Login As" option as "Local System Account" and click the OK button in the Properties dialog box. It is important to note that do not use a specified operating system account to start the SQLSer service, because the password of this account will not start normally.

5) Repeat the above operation to open the properties dialog. On the General page, select Startup type as Automatic. After clicking the "Start" button in "Service Status", click the OK button for the service properties.

3. Use Refresh in the context menu in the service list. Recheck the status of the mssqlserver service. Normally, the status should be "Started" and the startup type should be "Automatic".

4. Open Enterprise Manager, then Server - > Management - > sqlserver **, and then:

1) If the service is not started, right-click on SQLSer and select the Startup menu.

2) Right-click on "sqlserver" and select the "Properties" menu. In the SQL Server Properties dialog box, click the Advanced page, and in the Restart Service option, select the options "Automatic restart when SQL Server is unexpectedly stopped" and "Automatic restart when SQL Server is unexpectedly stopped".

5. If it still can't be started, it means that the program of sqlserver has been corrupted, and you can only reinstall sql server and sp4 patches on the server.

The question doesn't start.

The dependent service or group cannot be started.

Answer to bring up the run menu, then enter enter, find the SQL Server (MSSQLSserver) service, and set the login identity to the local system account.

See if there's a problem with your activation account. Go to the Windows Event Viewer and look for the error logs. There are detailed reasons for the error inside.

Start --> Management Tools --> Event Viewer --> Windows Logs --> Applications.

In the Control Panel, find "Services", where you can find all the services related to SQL Server and then start SQL Server

The mssqlserver service on the local machine started and then stopped. Some services automatically stop if they have nothing to do.

The author's ASP running environment: the operating system is Windows XP SP2, the version of IIS is the default, and the database is SQL Server 2005 (MDAC version is.

1. "The mssqlserver service on the local computer started and stopped. Some services automatically stop if they have nothing to do.

1.Get Started - > Manage Management Tools - > Services.

2.Start SQL Server (MSSQLSerder).

2. Solve the problem of "mssqlserver service on the local computer stopped after starting. Some services automatically stop if they have nothing to do.

1.Open the SQL Server Configure Manager tool in SQL Server 2005 and disable the VIA protocol.

2.Restart SQL Server (MSSQLSechServer) and succeed.

The mssqlserver service on the local machine started and then stopped. Some services automatically stop if they have nothing to do "Solve!"

As a side note, it may be that the evaluation version has expired and the system time has been changed

3."The mssqlserver service on the local computer started and then stopped. Some services automatically stop if they have nothing to do.

First, make sure that the sqlserver installation is successful.

Control Panel - Administrative Tools - Services Find sqlserver

Whether the SQL port is being used by other programs!

Program Menu -- SQL -- Configuration Tools -- SQL Server Configuration Manager Click on the SQL service inside to enable it.