Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)
Collapse the table of content
Expand the table of content

How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)

This topic describes how to add target servers to a multiserver administration configuration. Run this procedure from the master server.

For information about how the Windows account used for the SQL Server Agent service affects a multiserver environment, see Creating a Multiserver Environment.

Full Secure Sockets Layer (SSL) encryption and certificate validation is enabled for connections between master servers and target servers by default. For more information, see Setting Encryption Options on Target Servers.

To enlist a target server from a master server

  1. In Object Explorer, expand a server that is configured as a master server.

  2. Right-click SQL Server Agent, point to Multi Server Administration, and then click Add Target Servers.

  3. Complete the Target Server Wizard, which guides you through the process.

Community Additions

ADD
Show:
© 2015 Microsoft