SQL Server 2012 HA Cluster, Utility Controller No Data

Heyas,

I have turned Utility Controller on and enrolled my HA cluster.

Servers are run in passive mode and am logged on the first instance of the High Availability Cluster . Not the individual server itself.

It's been a week now, my question is why is no data coming through for the utility control point.

Any assistance is appreciated.

Thank you.
Capture.PNG
ZackGeneral IT Goto GuyAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
How did you remove the UCP? Did you follow this MSDN article?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check if the sysutility* jobs are running.
You can also read my article about the Utility Explorer to see if you performed all the steps.
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

Thank you will check this on monday.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

Checked everything in that article the jobs are running and the instances have been enrolled, no data though.

Thank you.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, can't remember in any other thing rather than drop and recreate the Utility Explorer.
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

I have dropped and tried to re-create the utility explorer when I try to recreate it get the following error.  See screenshot.

I have already dropped the utility database which was part of HA group.

Thank you.
UCP-Error.PNG
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

No I did not didn't release their was method, I will follow tomorrow and let you know.

Thank you.
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

Tried following the method, in the MSDN article the server is no longer a UCP instance in 'Managed Instances' in Utility explorer, see screenshot.

Also when I click on the server name, in Utility explorer I get the following error see screenshot.

Thank you.
UCP-Managed-Instances-Blank.PNG
UCP-Creation-error.PNG
0
 
ZackConnect With a Mentor General IT Goto GuyAuthor Commented:
Hi Vitor,

I followed this MSDN article and the UCP is now removed, problem solved.

https://msdn.microsoft.com/en-us/library/ee210565(SQL.105).aspx

The following command remove a managed instance of SQL Server from the SQL Server Utility.

EXEC msdb.dbo.sp_sysutility_mi_remove;

Thank you
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Thank you for your help Vitor.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Glad that I could help.
Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.