I have created a user and granted many permissions and roles to it including
My application checks the status of the SQL Server Agent to see if it is running or not, and whenever I am trying to run my application using the user I have created it is not able to identify a Running SQL Server Agent.
When I do the same thing using a user in the
sysadmin role it works fine.
We are using
master..xp_servicecontrol to check status of SQL Agent Service and I already provided user with
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO User;
Still it is not working. Any help?