Specifications

30 CHAPTER 2 Multi-Server Administration
Managed Instance Enrollment Prerequisites
As with many of the other tasks in this chapter, certain conditions must be satised to suc-
cessfully enroll an instance:
■
You must have administrator privileges on the instance of SQL Server.
■
The instance of SQL Server must be SQL Server 2008 R2 or higher.
■
The SQL Server edition must support instance enrollment.
■
The instance of SQL Server cannot be enrolled with any other UCP.
■
The instance of SQL Server cannot already be a UCP.
■
The instance of SQL Server must have the utility collection set installed.
■
The collection sets on the specied instance of SQL Server must be stopped.
■
The SQL Server Agent service on the specied instance must be started and congured
to start automatically.
■
The SQL Server Agent proxy account cannot be a built-in account such as Network
Service.
■
The SQL Server Agent proxy account must be a valid Windows domain account on the
specied instance.
Enrolling SQL Server Instances by Using SSMS
The following steps should be followed when enrolling a SQL Server instance via SSMS:
1. In Utility Explorer, connect to the desired SQL Server Utility (for example, Production
Utility), expand the UCP, and then select Managed Instances.
2. Right-click the Managed Instances node, and select Enroll Instance.
3. The Enroll Instance Wizard is launched. Review the introduction message, and then
click Next to begin the enrollment process. If you want, you can select the Do Not
Show This Page Again check box.
4. On the Specify The Instance Of SQL Server page, click the Connect button to specify
the instance of SQL Server to enroll in the UCP.
5. Supply the SQL Server instance name, and then click Connect in the Connect To Server
dialog box.
6. Click Next to proceed. The Utility Collection Set Account page is invoked.
7. There are two options available for specifying an account to run the utility collection
set. The rst option is a Windows domain account, and the second option is the SQL
Server Agent service account. You can use the SQL Server Agent service account only if
the SQL Server Agent service account is leveraging a Windows domain account. For se-
curity purposes, it is recommended that you use a Windows domain account with low
privileges. Specify the Windows domain account to be used as the SQL Server Agent
proxy account for the utility collection set, and then click Next to continue.