prevent SQL Server Agent to stop

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

prevent SQL Server Agent to stop

Author

Topic

vna_mhars
Starting Member

37 Posts

Posted - 2014-05-22 : 20:44:55

Hi,

Anyone can help me to prevent users from stopping sql server egent?
I have SQL2000 server installed and then SQL management studio 2008 R2 express edition in users desktop. I noticed that the user can stop the SQL server agent. Even a user is a reader access only.

vamodente

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-22 : 21:14:22

If the user is stopping a service, then that user has local admin or similar at the Windows level. You'll need to control this via permissions at the Windows layer.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

vna_mhars
Starting Member

37 Posts

Posted - 2014-05-22 : 21:27:33

Thanks TKizer, I had installed only Express edition of SQL management studio 2008 R2 in users.. then my users are all "power users" because of other application needs to be ran in powerusers. Is there a way to configure this in SQL server?

vamodente

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-22 : 21:31:10

No, this is a Windows issue, not a SQL Server issue.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

vna_mhars
Starting Member

37 Posts

Posted - 2014-05-22 : 21:46:44

Even the sql server agent is in the SQL management Studio 2008 R2?

vamodente

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-22 : 21:49:23

But it's a service at the Windows level.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

vna_mhars
Starting Member

37 Posts

Posted - 2014-05-22 : 21:54:24

Thanks Tara

I'm using Windows 7 professional with SQL Management Studio express edition. I went to services of windows but no SQL Services under the windows services.

Thanks

vamodente

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-22 : 22:06:15

I believe with SQL Server 2000, the services start with MSSQL.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

GouravSaxena1987
Starting Member

23 Posts

Posted - 2014-05-22 : 23:46:50

Hello,

It is not a issue related to SQL but it is something which can solve by Window Administrator.

If a window user has Admin/Power User rights then he will able to stop SQL agent.

So define your policy or change rights of users in window.

Regards,
Gourav Saxena
Data Warehouse Counsultant
GouravSaxena1987@gmail.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources