The instance of SQL server cannot be enrolled with any other UCP

  • Validation is failing while installing Utility Control Point. I did install before and then removed for some reason but wanted to install again but getting following error.

    The instance of SQL server cannot be enrolled with any other UCP.

    Appreciated any help.

  • Please ignore the previous message. This is being fixed by using following stored procedure.

    DECLARE @instance_id int;

    SELECT @instance_id = mi.instance_id

    FROM msdb.dbo.sysutility_ucp_managed_instances AS mi

    WHERE mi.instance_name = 'ComputerName\InstanceName';

    EXEC msdb.dbo.sp_sysutility_ucp_remove_mi @instance_id;

    EXEC msdb.dbo.sp_sysutility_mi_remove;

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply