February 25, 2008 at 1:45 pm
I am trying to stop my default instance of SQL Server so I can apply Service Pack 2. No service packs have been applied to the default instance. I have used Configuration Manager and Services under Administrative Tools. When I stop the MSSQLSERVER service, it appears stopped for a couple of seconds. When I refresh, it has automatically restarted. SQL Server Agen and FullText Search are stopped for this instance successfully.
A fellow DBA installed a named instance on the same server and only patched this instance a couple of weeks ago. I can successfully stop this service without it automatically restarting.
Any idea on how to get it to stay stopped. I have changed the startup type on the service to Manual, yet it contiues to restart the service when it stops.
Thanks
February 25, 2008 at 2:04 pm
Have you tried disabling the service? Did the event logs reveal any information on what account/process is responsible for restarting the service?
Tommy
Follow @sqlscribeFebruary 25, 2008 at 2:08 pm
Funny, I thought I had tried disabling it and it hadn't working. It work this time!
Event Logs just said:
User : NT AUTHORITY\SYSTEM
The SQL Server (MSSQLSERVER) service was successfully sent a start control.
thanks for your help!
February 25, 2008 at 2:30 pm
NP 🙂
Tommy
Follow @sqlscribeFebruary 27, 2008 at 10:03 am
Don't run your sql server on local system account. change that to a windows user account with necessary permissions. so that you don't have other issues with accessing network resources. also local system account has privileges over the machine and can do anything in the machine.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 2:35 am
Do you have any monitoring software running on your machine (e.g. NetIQ, OpenView, etc). These products can be configured to automatically start designated services if they are stopped.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply