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

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  August 13, 2012 at 7:52 am

  #280248

  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.

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  August 13, 2012 at 8:57 am

  #1525090

  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;