Specifications

28 CHAPTER 2 Multi-Server Administration
8. On the next page, the SQL Server instance is compared against a series of prerequisites
before the UCP is created. Failed conditions are displayed in a validation report. Cor-
rect all issues, and then click the Rerun Validation button to verify the changes against
the validation rules. To save a copy of the validation report for future reference, click
Save Report, and then specify a location for the le. To continue, click Next.
NOTE As mentioned in the prerequisite steps before these instructions, SQL Server
Agent is, by default, not congured to start automatically during the installation of SQL
Server 2008 R2. Use the SQL Server Conguration Manager tool to congure the SQL
Server Agent service to start automatically on the specied instance.
9. Review the options and settings selected on the Summary Of UCP Creation page, and
click Next to begin the installation.
10. The Utility Control Point Creation page communicates the steps and report status af-
liated with the creation of a UCP. The steps involve preparing the SQL Server instance
for UCP creation, creating the UMDW, initializing the UMDW, and conguring the SQL
Server Utility collection set. Review each step for success and completeness. If you wish,
save a report on the creation of the UCP operation. Next, click Save Report and choose
a location for the le. Click Finish to close the Create Utility Control Point Wizard.
Creating a UCP by Using Windows PowerShell
Windows PowerShell can be used instead of SSMS to create a UCP. The following syntax
(available in the article “How To: Enroll an Instance of SQL Server (SQL Server Utility),” online
at http://msdn.microsoft.com/en-us/library/ee210563(SQL.105).aspx), illustrates how to create
a UCP with Windows PowerShell. You will need to change the elements inside the quotes to
reect your own desired arguments.
NOTE When working with Windows Server 2008 R2, you can launch Windows PowerShell
by clicking the Windows PowerShell icon on the Start Menu taskbar. For more informa-
tion on SQL Server and Windows PowerShell, see “SQL Server PowerShell Overview” at
http://msdn.microsoft.com/en-us/library/cc281954.aspx.
$UtilityInstance = new-object –Type Microsoft.SqlServer.Management.Smo.Server
"ComputerName\UCP-Name";
$SqlStoreConnection = new-object –Type
Microsoft.SqlServer.Management.Sdk.Sfc.SqlStoreConnection
$UtilityInstance.ConnectionContext.SqlConnectionObject;
$Utility =
[Microsoft.SqlServer.Management.Utility.Utility]::CreateUtility("Utility",
$SqlStoreConnection, "ProxyAccount", "ProxyAccountPassword");