How can I Prevent The Stopping of SQlServiceAgent or other services related to SqlServer from my Application

Question

How can I Prevent The Stopping of SQlServiceAgent or other services related to SqlServer from my Application

MsCode_Pro

Say Hey Kid

Points: 690
More actions
June 19, 2008 at 4:56 am

#96490

Hello Experts, How can I Prevent The Stopping of SQlServiceAgent or other services related to SqlServer from my Application OR how can i audit it ,,,, and that FOR:
🙂 First, i want my application prevent the stopping of the SQL Services.
🙂 Second, if the first way impossible i want my C# application audit the SQL Services which responsible for the working of SQL-Server So when the Service of SQL begin Stopped my application Know about that Save the Data and Close the Application ,may be the user close the stops the service of sql while the application run So of course an exception will throwed and the Application lose important Data.
i think that this problem happened alot of times So i ask our experts what the solution of this Important Issue,,,,,,,,,,,,,,,
YoU CaN't LoSe WhAt YoU NeVeR HaD;)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Make sure that the users who use the appliction don't have rights to stop services (not SQL permissions, windows level permissions). Make sure no one but the server admins can stop the services.

How are the services been stopped?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

MsCode_Pro Say Hey Kid Points: 690 More actions · Answer 2

So the two ways are impossible

YoU CaN't LoSe WhAt YoU NeVeR HaD;)

MsCode_Pro Say Hey Kid Points: 690 More actions · Answer 3

I'll be wait for any solutions

YoU CaN't LoSe WhAt YoU NeVeR HaD;)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Mscode_Pro (6/19/2008)
So the two ways are impossible

What ways are impossible?

I'll be wait for any solutions

Be patient. We're all volunteers here. We're not paid to answer forum questions.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass