PowerProtect Data Manager 19.14 Microsoft SQL Server User Guide

Configuring primary and target SQL Server Agents

1. Open the Microsoft SSMS, and then select View > Object Explorer.
2. Right-click SQL Server Agent, and then select Multi Server Administrator > Make this a Master.

   The Master Server Wizard appears.

3. On the Welcome to the Master Server Wizard page, click Next.
4. On the Master Server Operator page, type the appropriate information in the E-mail address, Pager address, and Net send address fields to notify the operators about the status of the job, and then click Next.
5. On the Target Servers page:
   1. Under the Registered servers panel, select the servers that you want to use as targets for the SQL Server Agent jobs, and then click the right arrow to move them to the Target servers panel.
   2. If you want to add servers to the Registered servers panel, click Add Connection.
   3. In the Checking Server Compatibility dialog box, review the information, and then click Close.

      The Master Server Login Credentials page appears.

6. Enable Microsoft SQL Server remote connectivity:
   1. In SSMS, right-click the Microsoft SQL Server, and then click Properties.
   2. In the Server Properties window, under the Select a page group, select Connections.
   3. Select Allow remote connections to this server.
   4. Click OK.
7. Specify general firewall exceptions on the Microsoft SQL Server.
8. If an SSL certificate does not exist, set the encryption level on the target hosts to 1 or 0 according to the security level you need.
   To set the encryption level, change the MsxEncryptChannelOptions registry entry to 1 or 0. The registry key is located in \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance_name>\SQLServerAgent\.
9. On the Master Server Login Credentials page, click Next.
10. On the Complete the Wizard page, review the information, and then click Finish.