Stop SQL Server - using C#

Question

How can I use C# to stop SQL Server?

Answer 1

From http://www.csharp-examples.net/restart-windows-service/

public static void StopService(string serviceName, int timeoutMilliseconds)
{
  ServiceController service = new ServiceController(serviceName);
  try
  {
    TimeSpan timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds);

    service.Stop();
    service.WaitForStatus(ServiceControllerStatus.Stopped, timeout);
  }
  catch
  {
    // ...
  }
}

Answer 2

Execute from a SqlCommand: SHUTDOWN WITH NOWAIT;. The advantages over the other proposed solutions:

• this requires DB priviledges (sysadmin/serveradmin), not OS privileges
• works over any network firewall as long as T-SQL is let in (no extra ports needed)
• you don't need to figure out the service name (MSSQL$instancename)
• works if the service is started from console (sqlservr -c, not service start)

Answer 3

Try stopping the service.

using System.ServiceProcess;

...

ServiceController controller  = new ServiceController();

controller.MachineName = ".";
controller.ServiceName = "MySqlServerInstance";


controller.Stop();

Answer 4

Have you tried

Process.Start("net stop mssqlserver")