Solved

SQL Server 2012 HA Cluster, Utility Controller No Data

Posted on 2016-10-20
11
62 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 46

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 46

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 46

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 46

Expert Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

863 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

22 Experts available now in Live!

Get 1:1 Help Now