Thursday 25 April 2024

Report Server Configuration Manager: Unable to connect the the Report Server

Credit: Pedro Salinas-Ruiz - https://businesswintelligence.com/content/139/configuration-manager-ssrs-error 

Sometimes the WMI RS integration may become corrupted due to operating system updates or permission changes. If this happens, you may notice that Report Server Configuration Manager is unable to find the reporting instance on a server in which reporting services is DEFINITELY running in!
If this happens, we can rebuild the RS WMI component with a simple command. To do this, run the following command in an elevated command prompt. Make sure to change the path to the correct path relative to your installation directory and version.
mofcomp "C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\WMI\reportingservices.mof"
The default location for each version follows.

SSRS 2012
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin\reportingservices.mof
SSRS 2014
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin\reportingservices.mof
SSRS 2016
C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin\reportingservices.mof
SSRS 2017 and later
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\WMI\reportingservices.mof
Power BI Report Server
C:\Program Files\Microsoft Power BI Report Server\PBIRS\WMI\reportingservices.mof