Upravit

Sdílet prostřednictvím


Troubleshoot Multiserver Jobs That Use Proxies

Applies to: SQL Server

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

Distributed jobs whose steps are associated with a proxy run under the context of the proxy account on the target server. If job steps that use proxy accounts fail when downloaded from the master server, check the error_message column in the sysdownloadlist table in the msdb database for the following error messages:

  • "The job step requires a proxy account, however proxy matching is disabled on the target server."

    To resolve this error, set the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.<n>\SQLServerAgent\AllowDownloadedJobsToMatchProxyName registry subkey to 1 (true). By default, this subkey is set to 0 (false). The value of MSSQL.<n> is the instance name; for example, MSSQL.1 or MSSQL.3.

  • "Proxy not found."

    To resolve this error, make sure a proxy account exists on the target server with the same name as the master server proxy account under which the job step runs.

Caution

Incorrectly editing the registry can severely damage your system. Before making changes to the registry, we recommend that you back up any valued data on the computer.

See Also

Create a Multiserver Environment