| title | Remove a Utility Control Point (SQL Server Utility) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | configuration |
| ms.topic | conceptual |
| ms.assetid | c048a416-900e-4c77-8243-e0f0d8b94068 |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
This topic describes how to remove a [!INCLUDEssNoVersion] utility control point (UCP) from the instance of [!INCLUDEssNoVersion] in [!INCLUDEssCurrent] by using [!INCLUDEtsql].
In This Topic
-
Before you begin:
-
To remove a Utility Control Point, using:
Before you use this procedure to remove the UCP from the [!INCLUDEssNoVersion] Utility, note the following requirements. The stored procedure will run prerequisite checks as part of the operation.
-
Before you run this procedure, all managed instances of [!INCLUDEssNoVersion] must be removed from the UCP. Note that the UCP is a managed instance of [!INCLUDEssNoVersion]. From more information, see Remove an Instance of SQL Server from the SQL Server Utility.
-
This procedure must be run on a computer that is a UCP.
-
If the instance of [!INCLUDEssNoVersion] 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.
This procedure must be run by a user with sysadmin permissions; the same permissions required to create a UCP.
-
Connect to the [!INCLUDEssDE].
-
From the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute.
EXEC msdb.dbo.sp_sysutility_ucp_remove;
SQL Server Utility Features and Tasks
Use Utility Explorer to Manage the SQL Server Utility
Troubleshoot the SQL Server Utility