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
Solved

SQL Server 2012 HA Cluster, Utility Controller No Data

Posted on 2016-10-20
11
67 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 48

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 48

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 48

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 48

Expert Comment

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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
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.

828 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