Error Message

When trying to stop SQL Server service from Microsoft Service console (services.msc), user is presented with below message.



If sqlservr.exe process is killed (either from Windows Task Manager or from CLI), sqlservr.exe process restarts again.

SQL Server has a setting to auto restart SQL Server service if it goes down unexpectedly.

VCS version 6.x onwards has a feature called IMF (Intelligent Resource Monitoring) which monitors SQL Server instance and if IMF detects unexpectedly failure it will act based on the SQL server auto restart settings. i.e. if SQL Server auto restart attribute is set to True, then IMF will restart SQL Server service.

If there is a need to stop SQL Server service outside of cluster control (tasks such as troubleshooting or maintenance) then user can choose any one of the below listed options.

Option 1
Step 1: Stop VCS / HAD service using force option which only stop VCS service (application related resource will still be online).
hastop -local -force

Step 2: Stop SQL Server and perform required tasks.
Step 3: Once maintenance task is complete r estart VCS / HAD service .
hastart

Option 2
Step 1: Disable VCS IMF for SQL Server
haconf -makerw
hatype -modify SQLServer2008 IMF -update Mode 0
haconf -dump -makero

Step 2: Perform the maintenance task.
Step 3: O nce maintenance task is complete re-e nable VCS IMF for SQL Server.
haconf -makerw
hatype -modify SQLServer2008 IMF -update Mode 3
haconf -dump -makero

Note:
Above mentioned commands are for disabling and enabling IMF for SQL Server 2008 and 2008 R2. VCS has different agents to manage various SQL Server version. For example
VCS SQLServer2005 agent is used to manage SQL Server 2005 version
VCS SQLServer2008 agent is used to manage SQL Server 2008 and 2008 R2 versions.
VCS SQLServer agent is used to manage SQL Server 2012 version.

Change the agent type if using a different version of SQL Server.

Option 3:
Turn off Auto Restart setting for SQL Server (Refer to SQL Server documentation for steps to disable auto restart setting).

When Veritas Cluster Server (VCS) is configured to manage SQL Server instance, and there is a need to stop SQL Server service outside of cluster control (for tasks such as troubleshooting or maintenance) SQL Server service will not stop.

If VCS / HAD service is not running (already stopped) then  user is able to Stop SQL Server service.