I have some code that stops/starts the SQL Server Agent service from within our ASP.NET web application.ÃÂ Runs fine in development but doesn't in release - I suspect due to rights: Dev has admin rights, whereas Prod is running under a IIS application pool identity which is a domain account (e.g. IUSR_WEBAPP).
In Production it doesn't return any ManagedComputer.Services - ManagedComputer.Services.Count = 0. It doesn't throw any exceptions or anything, just not return any services or allow me to access the specific SQL Agent instance that I want to.
I've tried granting access in various places including WMI but nothing seems to work.ÃÂ I cannot figure out what rights might be needed.
How can I grant access to my application pool account so that it can enumerate services and stop/start my specific SQL Agent account instance for 2005/2008?
View Complete Post