Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 2012 HA Cluster, Utility Controller No Data

Posted on 2016-10-20
11
Medium Priority
?
89 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 52

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 52

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 52

Accepted Solution

by:
Vitor Montalvão earned 2000 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 52

Expert Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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 needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

618 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