CODEWITHSUNDEEP
sql-serverreporting-services
Yoa
Yoa

Reputation: 117

SQL Server Report Service Stuck until I Stop/Start service

Frequently when we try to open up any SQL report, it just sits there. I then go to the database server and stop/start the SQL Reporting service. That fixes the reports for a week or 2, but it would then need reset again. I need to find what is the issue and how to resolve it. I'm using SQL Server 2012.

Please could anybody have an idea about what's happening.

Thanks

Upvotes: 1

Views: 2461

Answers (1)

Arman Peiravi
Arman Peiravi

Reputation: 1098

If you're using Windows Server 2012 and assuming you've installed to the default location, a good place to look for root cause is in the logs located at:

C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles

The next time this happens, open the most recent log file and search for any errors.

Upvotes: 1

Related Questions