How to: Remove a Utility Control Point (SQL Server Utility)

Use the following steps to remove a SQL Server utility control point (UCP) from the SQL Server Utility. This procedure removes the UCP from the instance of SQL Server. After the operation is complete, a UCP can be created on the instance of SQL Server again.

Before you use this procedure to remove the UCP from the SQL Server Utility, note the following requirements. The stored procedure will run prerequisite checks as part of the operation.

  • This procedure must be run by a user with sysadmin permissions; the same permissions required to create a UCP.

  • Before you run this procedure, all managed instances of SQL Server must be removed from the UCP. Note that the UCP is a managed instance of SQL Server. From more information, see How to: Remove an Instance of SQL Server from the SQL Server Utility.

  • This procedure must be run on a computer that is a UCP.

Remove a utility control point

  1. Use SQL Server Management Studio to connect to the UCP, then run this script:

    EXEC msdb.dbo.sp_sysutility_ucp_remove;

Note: If the instance of SQL Server where the UCP was removed has a non-Utility data collection set, the UMDW database (sysutility_mdw) will not be dropped by the procedure. If this is the case, the UMDW database (sysutility_mdw) must be dropped manually before the UCP can be created again.