"The SQL SERVER service on the local computer is stopped after it starts." Solution

This method mainly solves the problem that the MSSQLSERVER service on the local computer starts after the SQL Server is running. Some services are automatically stopped if they do not have What can be done" solution.

The author ASP running environment: the operating system is Windows XP SP2, the version of IIS is the default 5.1, the database is SQL Server 2005 (MDAC version is 2.8)

First, the MSSQLSERVER service on the local computer appears. After startup, it stops again. Some services are automatically stopped if they have nothing to do."

1.Start-->Management Management Tools-->Services

0 && ; image.height>0){if(image.width>=700){this.width=700;this.height=image.height*700/image.width;}}" border=0> 2. Start SQL Server (MSSQLSERVER )

0 && image.height>0){if(image.width>=700){this.width=700;this .height=image.height*700/image.width;}}" border=0>0 && image.height>0){if(image.width>=700){this.width=700;this. Height=image.height*700/image.width;}}" border=0>

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

0 && image.height>0){if(image.width>=700){this.width=700;this.height =image.height*700/image.width;}}" border=0> Second, solve "the MSSQLSERVER service on the local computer starts and then stops. Some services stop automatically, if they have nothing to do"

1. Open the SQL Server Configure Manager in SQL Server 2005 and disable the VIA protocol
0 && image.height>0){if(image.width>=700){this.width =700;this.height=image.height*700/image.width;}}" border=0>
0 && image.height>0){if(image.width>=700){this .width=700;this.height=image.height*700/image.width;}}" border=0>

2. Restart SQL Server (MSSQLSERVER), successful
0 && ; image.height>0){if(image.width>=700){this.width=700;this.height=image.height*700/image.width;}}" border=0> "On the local computer The MSSQLSERVER service stopped after it started. Some services stop automatically if they have nothing to do" solve!