Hey all,
It might just be that its late, but im getting rather confused.
Logging into SQL with Windows Auth.
Account is part of Domain Admin
Account is SysAdmin for the instance.
Running
XP_servicecontrol 'stop', 'sqlserveragent'
gets the error
StartService() returned error 5. 'Access is denied'
Surely that should work!? Im guessing its running like xp_cmdshell so using the SQL Service account? Ive not given the service account any special permissions.. I dont see it noted anywhere that its needed? am i wrong?
Hoping someone can set me straight!
S