Solved

SQL Server 2012 HA Cluster, Utility Controller No Data

Posted on 2016-10-20
11
58 Views
Last Modified: 2016-11-15
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
0
Comment
Question by:Zack
  • 7
  • 4
11 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41853313
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
 

Author Comment

by:Zack
ID: 41853402
Hi Vitor,

Thank you will check this on monday.
0
 

Author Comment

by:Zack
ID: 41858019
Hi Vitor,

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

Thank you.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41878242
Sorry, can't remember in any other thing rather than drop and recreate the Utility Explorer.
0
 

Author Comment

by:Zack
ID: 41881584
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41881747
How did you remove the UCP? Did you follow this MSDN article?
0
 

Author Comment

by:Zack
ID: 41882157
Hi Vitor,

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

Thank you.
0
 

Author Comment

by:Zack
ID: 41883123
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
 

Assisted Solution

by:Zack
Zack earned 0 total points
ID: 41887343
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
 

Author Closing Comment

by:Zack
ID: 41887344
Thank you for your help Vitor.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41887466
Glad that I could help.
Cheers
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now