Posted on : 05-07-2011 | By : Devi Prasad | In : PROXIES




SQL Server Proxy is a named holder of SQL Server Credentials.
SQL Server Proxies are basically used to definte the security context of a job step.
These proxies provide the job with the security credentials that were defined by the proxy.
The sql server agent first imporsinates the security credentials of the proxy and then runs the job step.

For example if there are two sql servers, server A and the other server B.
There is a requirement where in one step in the agent job on server A has to access the data from one of the tables in server B.
Let us suppose X has read permissions on server B.
Now in order to give the Job step permission on server B the following steps are performed on server A:

  • New Credential for X is created (i.e Identity and password are saved)
  • New Proxy is created using the credential created above.
  • The proxy is mapped with the subsystem as required.(this depends on what the job step does)
  • The job step is modified to use this proxy.

References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.

Write a comment