Figure 1 – SSRS error during setup of SQL Reporting
You’ve installed SQL. Everything went well and you have all the different tasks showing as being successful. Then you go to install SSRS Reporting Services, and you get the message….
I keep getting ‘Cannot connect to SERVERNAME’, ‘Report Server WMI Provider Error: Invalid namespace
The answer to fixing this error, at least the answer that worked for me, is:
To install/reinstall/repair SSRS, run the SQL Server setup utility and choose the advanced or custom option which will allow you to choose only the components you wish to install.
Big question – what does the Utility Control Point do?
The SQL Server Utility is managed through a utility control point using Utility Explorer in SSMS. The UCP is configured on an instance of SQL Server. It provides the central reasoningpoint for the SQL Server Utility using SSMS to organize and monitor SQL Server resource health.
1. To create the SQL Server Utility begin with opening the SQL Server Management Studio. I am using SQL 2014.
2. Then click on VIEW, and find UTILITY EXPLORER, as below.
3. Click on UTILITY EXPLORER to open up the next window, and click on CREATE UTILITY CONTROL POINT.
4. This opens up the window below which gives you very clear steps to follow to create the Utility Control Point.
The process of creating and validating the SQL Server instance cleared up the issues that I had with WMI not distinguishing instance names, and solved my problem. I was able to install Reporting Services, and to configure SSRS reporting to suit my requirements.