February 16, 2012 at 10:14 am
Hi All,
I am trying to setup the utility control points but I am getting this error on all of my instances.
Msg 37007, Level 16, State 1, Procedure sp_sysutility_mi_upload, Line 120
An error occurred during upload to the SQL Server utility control point.
Can anyone help we with this error. It is a basic install but we are using different port numbers for the instances.
Anyways if any one has any ideas let me know.
Thanks
February 16, 2012 at 12:12 pm
Adam,
I have no idea what the SQL Server utility control point is. Could you point me to a reference so I can read up on it and see if I know it by a different name?
February 16, 2012 at 12:23 pm
I would check on the credentials used to set up the UCP. @Brandie, UCP is a way to monitor several SQL Servers from 1 and set up a data warehouse to hold and report off of the data. Pretty cool actually. http://msdn.microsoft.com/en-us/library/ee210548.aspx
Jared
CE - Microsoft
February 16, 2012 at 12:29 pm
SQLKnowItAll (2/16/2012)
I would check on the credentials used to set up the UCP. @Brandie, UCP is a way to monitor several SQL Servers from 1 and set up a data warehouse to hold and report off of the data. Pretty cool actually. http://msdn.microsoft.com/en-us/library/ee210548.aspx
Thanks for the reference, Jared. I appreciate it.
February 16, 2012 at 12:32 pm
Brandie Tarvin (2/16/2012)
SQLKnowItAll (2/16/2012)
I would check on the credentials used to set up the UCP. @Brandie, UCP is a way to monitor several SQL Servers from 1 and set up a data warehouse to hold and report off of the data. Pretty cool actually. http://msdn.microsoft.com/en-us/library/ee210548.aspxThanks for the reference, Jared. I appreciate it.
No problem 🙂 but be careful, once it is enabled it is extremely difficult to disable. Here's a good video as well. http://www.youtube.com/watch?v=sRUcmR5HRrI
Jared
CE - Microsoft
February 16, 2012 at 1:41 pm
@sqlknowitall Thanks for the information, I have it setup using the SQL Service AD account... figured it would have the most access; alias it didn't have enough and the error message is pretty weak.
For now I have removed it by following the MSDN instructions.
Removing the Instance
http://technet.microsoft.com/en-us/library/ee210565.aspx
Removing the UCP Server
http://technet.microsoft.com/en-us/library/ff487180.aspx
February 16, 2012 at 1:46 pm
Glad to help!
Jared
CE - Microsoft
July 30, 2012 at 1:28 pm
You generally want to track the 2 jobs used by the UCP that run on the server being monitored.
sysutility_mi_collect_performance and sysutility_mi_collect_and_upload.
sysutility_mi_collect_and_upload is most likely the one that has errors.
The errors are probably due to a security issue.
I've had success resolving the issue by changing the monitoring account to something that should have permissions to the locations involved,
if only for a moment just to get some data moving.
After it starts working, you can switch the UCP monitoring settings back to what they were before and it should continue to work.
July 30, 2012 at 1:34 pm
Thanks for the details but we have abandoned this idea as other solutions are better suited (currently) but SQL 2012 might be better.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply