Stop SQL Server - using C#

Question

How can I use C# to stop SQL Server?

Answer 1

Try stopping the service.

using System.ServiceProcess;

...

ServiceController controller  = new ServiceController();

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


controller.Stop();

Answer 2

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 3

Have you tried

Process.Start("net stop mssqlserver")

Answer 4

using System.Diagnostics;

public static bool StopProcess(string name)
{
    try
    {
        var process = Process.GetProcesses().SingleOrDefault(p => p.ProcessName == name);
        process.WaitForExit(); 
        return true;
    }
    catch (Exception)
    {
        //throw;
        return false;
    }
}

Answer 5

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)