CODEWITHSUNDEEP
sql-server-2008reporting-servicesssrs-2008
Amarundo
Amarundo

Reputation: 2397

Unable to connect to the Report Server - Can't find service

Over the weekend the SQL Server 2008 R2 (running on Windows Server 2008 R2) was rebooted.

This morning my reports don't run.

I try to login to SQL Server 2008 R2 Reporting Services Configuration Manager and it gives me an error: Unable to connect to the Report Server

I did some searches and found this, but I don't see any service called Report Server. I also don't see any services that - by its name - seem to be the reporting service when running SQL Server Configuration Manager.

Ideas?

Thanks.

Upvotes: 1

Views: 40805

Answers (2)

Kk2438
Kk2438

Reputation: 11

WMI RS integration may become corrupted due to operating system updates or permission changes.

Find the path for file reportingservices.mof in your SSRS installed location. i.e under:

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\WMI -- for 2017 SSRS

Run the following in cmd with the path:

mofcomp "C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\WMI\reportingservices.mof"

Upvotes: 1

Jamie F
Jamie F

Reputation: 23809

The link you provided was for the 2012 version. Use the appropriate version of the link for a few ideas:

http://msdn.microsoft.com/en-us/library/ms143773(v=sql.105).aspx

If the Reporting Services Configuration Manager can't be launched, I would check the system event logs for errors pointing in the right direction: This could be a lot of things: permissions, SQL connectivity problems, certificate expiration, &c.

Edit: the service name is still incorrect in the corret version of the docs I provided. The default instance of this service is called

SQL Server Reporting Services (MSSQLSERVER)

If you have multiple instances of SSRS installed there will be multiple services listed, with the instance name in parenthesis.

Upvotes: 1

Related Questions