Enlist a Target Server to a Master Server

This topic describes how to add target servers to a multiserver administration configuration. Run this procedure from the master server. in SQL Server 2012 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects (SMO).

For information about how the Windows account used for the SQL Server Agent service affects a multiserver environment, see Create 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 Set Encryption Options on Target Servers.

In This Topic

  • To enlist a target server, using:

    SQL Server Management Studio



Using SQL Server Management Studio

To enlist a target 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.

Using Transact-SQL

To enlist a target server

Using SQL Server Management Objects (SMO)

SQL Server Management Objects (SMO)

See Also


Automated Administration Across an Enterprise