Loading

How can I start or stop a sql server in c#

Chengxing Gao

I am writing a test class. In this class, I need to stop the sql server in Setup() method, and restart the sql server in Teardown() method. I don't know how to stop or start the sql server in c#. anyone can help me ?

thx in advance~

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

surendra kumar18y ago
If u add reference of Com component SqlDmo class then u can easly Start and stop sql service in C#
Blocked Account18y ago
Hi,
First u have to add the reference of the System.ServiceProcess.dll and after that create the object of the ServiceController like this:

ServiceController objServiceController = new ServiceController("MSSQLSERVER");

For start the server write this:
objServiceController.Start();

For stop the server write this:
objServiceController.Stop();