Solved

SQL Server 2012 HA Cluster, Utility Controller No Data

Posted on 2016-10-20
11
79 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 50

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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 50

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
 
LVL 50

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 50

Expert Comment

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

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

690 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