MSSQLServer Service changes to Disabled

MSSQLServer Service changes to Disabled

Post by Spyder Byt » Wed, 13 Nov 2002 04:05:26

SQL 2000 (SP2) on Windows 2000 Server (SP3)

The MSSQLSERVER service keeps changing to Disable. When the server is
restarted the MSSQLSERVER service is Disabled. I change the service to
Automatic. The service is then started. The services show MSSQLSERVER
service as 'Started' and 'Automatic'. I will then go back (an hour or
so later) and look at the service and the service is still 'Started'
but the startup type is changed back to 'Disabled'.

I have also gone in to the Enterprise Manager (in the properties of
the specific SQL server) and checked the 'Autostart SQL Server' under
the autostart policies when the operating system starts (on the
Properties General tab).

Any thoughts on what might toggling this service to disable?

Is there a registry setting that is messed up and this is changing the
Service back to Disabled?

I have also considered going back to the SQL install CD and selecting
the Advanced option and rebuilding the registry. I am cautious about
doing this since I am not sure if it will change any other SQL
configurations. What will the registry rebuild change?



1. Changing MSSQLServer Service user account

When using Enterprise Manager in SQL 7.0 to change the SQL Service from
system account to an NT User Account I am getting:

A required privilege is not held by the client

It seems that Enterprise Manager is using an account that does not have
rights to make this change. I am using "sa" to connect to the server in
Enterprise Manager. How can I change from the system account to an NT

2. Entries in the alert log for archiving

3. Changing the service account MSSQLServer runs under

4. Group by count() and indexes

5. A service control operation failed for the MSSQLServer service

6. can one call COM obj from SQL server?

7. SP 3 Error: MSSQLServer Service: 1460

8. Timeout expired for stored procedure won't go away

9. Unable to stop MSSQLSERVER or SQLSERVERAGENT services

10. MSSQLSERVER service terminated unexpectedly

11. Error 1067 when attempting to start MSSQLServer Service

12. MSSQLServer Service Stop

13. MSSQLServer Service Sporadically Stops & Restarts