Here I have a scenario where I can use subInACL to grant START/STOP/PAUSE permissions to MSSQLSERVER and SQLSERVERAGENT with "NT AUTHORITY\NETWORK SERVICE" account .
subinacl.exe /service MSSQLSERVER /grant="NT AUTHORITY\MSSQLSERVER"=PTO
subinacl.exe /service SQLSERVERAGENT /grant="NT AUTHORITY\SQLSERVERAGENT"=PTO
The above two commands work fine and resolve the Access Denied issue when I start/stop the service using xp_servicecontrol .
However I was looking for an alternative to do the same without having to donwload subInACL and then use it . Any help on this will be much appreciated!
Aucun commentaire:
Enregistrer un commentaire