Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS 2008 - Reporting Services Webpage is Blank except for headers

I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space.

I'm on SQL 2008 and Windows Server 2008 R2 Standard.

Any ideas how to fix? I've confirmed that I am logged in as a local administrator. I tried adding the URL to trusted sites but that didn't seem to help either.

Update

When I go to the ReportServer URL I get this error message:

Reporting Services Error
--------------------------------------------------------------------------------

The permissions granted to user 'DTNT\greg' are insufficient for performing this operation. (rsAccessDenied) Get Online Help 

--------------------------------------------------------------------------------
SQL Server Reporting Services 
like image 504
Greg Avatar asked Feb 26 '23 16:02

Greg


1 Answers

Solved it, sort of! I tried right clicking IE and selecting run as administrator, and then going to the report manager URL and everything worked properly.

I clicked on site settings on the top right of the page and added the greg user as a system administrator and system user.

I also added the greg user as a content manager on the root directory.

IT still says I was already a local administrator on that machine, but this seemed to be required to make it work.

Any thoughts why that was necessary?

like image 145
Greg Avatar answered Mar 22 '23 23:03

Greg