sql server - Alternative of subInACL to grant permissions to a service? -


here have scenario can use subinacl grant start/stop/pause permissions mssqlserver , sqlserveragent "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 2 commands work fine , resolve access denied issue when start/stop service using xp_servicecontrol .

however looking alternative same without having donwload subinacl , use . on appreciated!


Comments

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -