Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-01 : 08:35:30
|
| Russ Reed writes "SQL Server 2000 SP1 on Windows 2000 Server SP2The MSSQLSERVER service keeps changing to Disable. When the server is restarted the MSSQLSERVER service is Disabled. The service is changed to Automatic and applied. The service is then started. The services show MSSQLSERVER service as 'Started' and 'Automatic'. I will then go back and look at the service the next day 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?ThanksRuss" |
|
|
|
|
|
MSSQLSERVER service keeps changing to Disable