How to: Enroll an Instance of SQL Server (SQL Server Utility)

Wizard Steps

The following sections provide detailed information about each page in the Wizard work flow. Click on a link to navigate to details for a page in the Wizard. For more information about a PowerShell script of this operation, see the PowerShell example.

• Introduction to Enroll Instance Wizard

• Specify the Instance of SQL Server

• Connection Dialog

• Utility Collection Set Account

• SQL Server Instance Validation

• Summary of Instance Enrollment

• Enrolling the Instance of SQL Server

Introduction to Enroll Instance Wizard

To launch the Wizard, expand the Utility Explorer tree on a utility control point, right-click on Managed Instances, and select Add Managed Instance….

To continue, click Next.

Specify the Instance of SQL Server

To select an instance of SQL Server from the connection dialog box, click Connect…. Provide the computer name and the SQL Server instance name in the format ComputerName\InstanceName. For more information, see Connect to Server (Database Engine).

To continue, click Next.

Connection Dialog

On the Connect to Server dialog box, verify the server type, computer name, and SQL Server instance name information. For more information, see Connect to Server (Database Engine).

To continue, click Connect….

Utility Collection Set Account

Specify a Windows domain account to run the SQL Server Utility collection set. This account is used as the SQL Server Agent proxy account for the SQL Server Utility collection set. Alternatively, you can use the existing SQL Server Agent service account. To pass validation requirements, use the following guidelines to specify the account.

If you specify the SQL Server Agent service account option:

• The SQL Server Agent service account must be a Windows domain account that is not a built-in account like LocalSystem, NetworkService, or LocalService.

To continue, click Next.

SQL Server Instance Validation

In this release, the following conditions must be true on the instance of SQL Server to be enrolled into the SQL Server Utility:

If there are failed conditions in the validation results, correct the blocking issues and then click Rerun Validation to verify the computer configuration.

To save the validation report, click Save Report then specify a location for the file.

To continue, click Next.

Summary of Instance Enrollment

The summary page lists the information about the instance of SQL Server to add to the SQL Server Utility.

Managed Instance Settings:

• SQL Server Instance Name: ComputerName\InstanceName

• Utility Collection Set Account: DomainName\UserName

To continue, click Next.

Enrolling the Instance of SQL Server

The Enrolling page provides status of the operation:

• Preparing the instance for enrollment.

• Creating the cache directory for the collected data.

• Configuring the utility collection set.

To save a report about the enroll operation, click Save Report then specify a location for the file.

To complete the Wizard, click Finish.

After completing the Enroll Instance Wizard, click on the Managed Instances node in the Utility Explorer Navigation pane in SSMS. Enrolled instances of SQL Server are displayed in the list view in Utility Explorer Content pane.

The data collection process begins immediately, but it can take up to 30 minutes for data to first appear in the dashboard and viewpoints in the Utility Explorer content pane. Data collection continues one time every 15 minutes. To refresh data, right-click the Managed Instances node the Utility Explorer Navigation pane, then select Refresh, or right-click on the SQL Server instance name in the list view, then select Refresh.

To remove managed instances from the SQL Server Utility, select Managed Instances in the Utility Explorer Navigation pane to populate the list view of managed instances, right-click on the SQL Server instance name in the Utility Explorer Content list view, then select Make Instance Unmanaged.

Enroll an Instance of SQL Server using PowerShell

Use the following example to enroll an instance of SQL Server into an existing SQL Server Utility:

> $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]::Connect($SqlStoreConnection);
> $Instance = new-object -Type Microsoft.SqlServer.Management.Smo.Server "ComputerName\ManagedInstanceName";
> $InstanceConnection = new-object -Type Microsoft.SqlServer.Management.Sdk.Sfc.SqlStoreConnection $Instance.ConnectionContext.SqlConnectionObject;
> $ManagedInstance = $Utility.EnrollInstance($InstanceConnection, "ProxyAccount", "ProxyPassword");

See Also

Concepts

Other Resources