Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
This topic describes how to add target servers to a multiserver administration configuration. Run this procedure from the master server. in SQL Server 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 Transport Layer Security (TLS), previously known as 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 Object Explorer, expand a server that is configured as a master server.
Right-click SQL Server Agent, point to Multi Server Administration, and then click Add Target Servers.
Complete the Target Server Wizard, which guides you through the process.
- Use the sp_msx_enlist stored procedure. For more information, see sp_msx_enlist (Transact-SQL)