Specifications

26 CHAPTER 2 Multi-Server Administration
Creating a UCP
The UCP is relatively easy to set up and congure. You can deploy it either by using the
Create Utility Control Point Wizard in SSMS or by leveraging Windows PowerShell scripts.
The high-level steps for creating a UCP include specifying the instance of SQL Server in which
the UCP will be created, choosing the account to run the utility control set, ensuring that the
instance is validated and passes the conditions test, reviewing the selections made, and nal-
izing the UCP deployment.
Although the setup is fairly straightforward, the following conditions must be met to suc-
cessfully deploy a UCP:
■
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 UCP creation.
■
The instance of SQL Server cannot be enrolled with any other UCP.
■
The instance of SQL Server cannot already be a UCP.
■
There cannot be a database named sysutility_mdw on the specied instance of SQL
Server.
■
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.
Creating a UCP by Using SSMS
It is important to understand how to effectively use the Create Utility Control Point Wizard in
SSMS to create a SQL Server UCP. Follow these steps when using SSMS:
1. In SSMS, connect to the SQL Server 2008 R2 Database Engine instance in which the
UCP will be created.
2. Launch the Utility Explorer by selecting View and then selecting Utility Explorer.
3. On the Getting Started tab, click the Create A Utility Control Point (UCP) link or click
the Create Utility Control Point icon on the Utility Explorer toolbar.
4. The Create Utility Control Point Wizard is now invoked. Review the introduction mes-
sage, and then click Next to begin the UCP creation process. If you want, you can
select the Do Not Show This Page Again check box.