Do you really mean the UCP? It is a centrally managed SQL Server collecting and monitoring data from different other MSSQL instances, something you only use in "bigger" environments.
Nakul VachhrajaniConnect With a MentorTechnical Architect, Capgemini IndiaCommented:
It looks like you have a default instance, hence the instance name in the script should be set to "UCH-SQLC01-D001", not "UCH-SQLC01-D001\MSSQLSERVER". Can you update the instance name in the script and try again?
Can you connect it from SSMS (remote)?
on UCH-SQLC01-D001 server check if Sql server Browser service is running,,
0
WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network. Check out this quarters report on the threats that shook the industry in Q4 2017.
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The error message doesn't fit to the script, The error messages wants to connect a local unnamed instance, while the script is about a remote or local named instance. What is your $UcpServerInstanceName, and as asked above, your local instance name (if any)?
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I've reviewed your question again, and see a conflict. Do you really want to connect to MSSQL to get your instance name? If so, above code is the wrong approach, as it requires you to know the instance name already.
0
ZackGeneral IT Goto GuyAuthor Commented:
Hi Qlemo,
I will embed code in future thank you. As for my query, I am trying to 'Remove an Instance of SQL Server from the SQL Server Utility' and using the script provided to me in this article: https://msdn.microsoft.com/en-us/library/ee210565.aspx.
Since the method described in the article is the wrong approach what would be the right approach?
Thank you.
0
ZackGeneral IT Goto GuyAuthor Commented:
Hi Qlemo,
My manager told me to try to get Utility Explorer working for this server instance, so I am trying to get the UCP working.