When you install SQL Server, it installs 3 services that start up when you start your computer. These services are named:
- MSSQLSERVER
- MSSQLServerADHelper
- SQLSERVERAGENT
The MSSQLServerADHelper and SQLSERVERAGENT services are easy to prevent from starting up. You just go to their Properties in the Services Control Panel applet and change them to a Manual Startup Type. However, MSSQLSERVER will continue to start if you set it to Manual.
I have no idea why this happens. The only way I've found to prevent it from starting automatically is to set it to Disabled. This will prevent it from stating up at boot. However, you have to set the service back to Manual if you want to start it. I usually just set it to Manual, start it, then immediately set it back to Disabled so I don't forget to do it when I turn off my computer again.
11:55:17 AM
|