Learning the Tricks of the Trade - Microsoft SQL Server 2008 R2 Administration - page 406

7. Checking the Server Compatibility screen will process the addition of the master

server and target servers. While checking server compatibility, if there are any errors,
the Status and Message columns will display the relevant information.

8. There is a problem in connecting to DBIA-SSQA\SQLExpress because the specified

instance SQL Server service has not been started. To correct the Compatibility check
failure for SQLExpress instance, the service has been started that completes the
Checking Server Compatibility process.

9. Next, the Master Server Login Credentials screen is presented to specify the

account that is used for the target server to connect to the master server. Click Next
to continue.

Ensure to select the option Create a new login, if necessary. Assign rights to
the MSX, as it is essential to allow the target server to use Windows security
to connect to the master server and download jobs for the SQL Server Agent.

10. The selection will enable the process to complete that will verify the choices made in
the wizard. Click Finish to Enlist TSX Progress.
11. SQL Server Books On Line (BOL) documentation highlights the essential security
settings for the distributed jobs. Make sure the following registry key is set so that job
steps that are associated with a proxy will not be downloaded from the master server
to the target server.
The master server registry sub-key: \HKEY_LOCAL_MACHINE\SOFTWARE\
Microsoft\Microsoft SQL Server\<instance_name>\SQL Server Agent\
AllowDownloadedJobsToMatchProxyName (REG_DWORD) is set to 1
(true). By default, this sub-key is set to 0 (false).