How to Configure SQL Server Agent Multiserver Jobs with Proxies?

You have two Azure virtual machines named Server1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com. Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server. On Server1, you create a proxy account named contoso\sqlproxy. You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.
On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.
On Server2, create a proxy account. Source Reference Answer
On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. Source Reference Answer
On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.

Community Votes

78%

22%

78% of anonymous learners picked answer CD. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests knowledge of multiserver job proxy synchronization; the common trap is setting the registry key on the target server instead of the master server.

This question tests the configuration of SQL Server Agent multiserver (master/target) job downloading when proxy accounts are involved. Community consensus confirms that creating a matching proxy on the target server and setting the AllowDownloadedJobsToMatchProxyName registry key on the master server are required.

Option E is the most common wrong answer because candidates assume the registry setting must be applied on the target server (Server2) where the jobs actually execute, but Microsoft documentation specifies it must be set on the master server (Server1).

Community Discussion (5 comments)

jtrain 👍 4 Selected: CD

The answer is C and D. https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-target-server?view=sql-server-ver16

st1a 👍 3

C,E Distributed jobs that have steps which are associated with a proxy run under the context of the proxy account on the target server. Make sure that the following conditions are met or job steps that are associated with a proxy will not be downloaded from the master server to the target: The master server registry subkey \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance_name>\SQL Server Agent\AllowDownloadedJobsToMatchProxyName (REG_DWORD) is set to 1 (true). By default, this subkey is set to 0 (false). A proxy account exists on the target server that has the same name as the master server proxy account under which the job step runs.

04db10c 👍 2 Selected: DE

D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. This registry entry allows SQL Server Agent jobs on Server1 to use the proxy account name (contoso\sqlproxy) when executing on Server2. This is essential for ensuring that the job steps are executed with the appropriate permissions on Server2. E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. Similarly, on Server2, setting this registry entry ensures that the downloaded job steps from Server1 can be executed using the proxy account (contoso\sqlproxy). This step ensures compatibility and security when job steps are executed on the target server (Server2). Therefore, the correct actions to perform are D and E: D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1. These actions ensure that the SQL Server Agent jobs from Server1 can be downloaded and executed on Server2 using the specified proxy account, contoso\sqlproxy, while maintaining security and compatibility between the servers.

pjfunner 👍 3 Selected: CD

ChatGPT suggests C and D: Therefore, the correct answers are: C. On Server2, create a proxy account. D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 112. These actions will ensure successful execution of SQL Server Agent job steps between Server1 and Server2.

angelvenkovicch 👍 1 Selected: AE

I think it's A,E

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Expert Analysis

Why the Answer Is Correct

Option C is correct because a proxy account must exist on the target server (Server2) with the same name as the one on the master server for downloaded job steps to execute under the proper security context. Option D is correct because the AllowDownloadedJobsToMatchProxyName registry entry must be set to 1 on the master server (Server1) to allow job steps associated with a proxy to be downloaded to the target server. Together, these two actions satisfy the prerequisites outlined in Microsoft documentation for multiserver job proxy execution.

Why the Other Options Are Wrong

Option A (Impersonate a client after authentication) and Option B (Access this computer from the network) are local user rights that are not specifically required for multiserver job proxy downloading. Option E is incorrect because the AllowDownloadedJobsToMatchProxyName registry key must be set on the master server, not the target server; applying it on Server2 will not resolve the download issue.

Community Comment Notes

The majority of voters (70) selected CD, aligning with Microsoft documentation. Comment [1] directly links to the official MS Learn article confirming the answer. Comment [2] highlights the registry path and notes that conditions must be met on the master server, indirectly supporting D over E. Comment [4] represents the minority DE camp, mistakenly applying the registry setting to the target server.

Official Reference

Exam Strategy

For multiserver SQL Server Agent questions, always identify which server is the master and which is the target before evaluating options. Registry keys and configuration settings for job downloading are typically applied on the master server, not the target.

Related Analysis

Practice All DP-300 Questions

Access 105 questions with complete answers and detailed explanations.

View Full DP-300 Practice Test →

← Back to DP-300 Study Guide