I have just created a proxy and I need to grant access to the proxy to the account that runs the sql server agent. It will probably be a domain account.
How can I find it using T-SQL?
dmvsql serversql server 2014
I have just created a proxy and I need to grant access to the proxy to the account that runs the sql server agent. It will probably be a domain account.
How can I find it using T-SQL?
Best Answer
In SQL Server 2005 and SQL Server 2008 there was no documented way. So undocumented command
xp_regread
was used to get the resultSince SQL Server 2008R2 SP1 we have a documented way to get to this information:
sys.dm_server_services
hereYou can use below query to find the same: