SSRS 2008 - Reporting Services webpage is blank except for headers

Question

I get a blank page when opening the Report Manager: I have a heading - "... Reporting ... HOME", and then just blank space.

I am in the SQL 2008 and Windows Server 2008 R2 standard.

Any ideas how to fix it? I confirmed that I am registered as a local administrator. I tried adding the URL to trusted sites, but that didn't help either.

Update

When I go to the ReportServer URL, I get the following 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 

Answer 1

Decided like! I tried right-clicking on IE and choosing run as administrator, and then go to Report Manager URL and everything works correctly.

I clicked on the site settings in the upper right corner of the page and added the greg user as the system administrator and system user.

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

IT still says that I was already the local administrator on this machine, but it seemed to be required to get it working.

Any thoughts why this was necessary?

Answer 2

Send a message: https://stackoverflow.com/questions/1540800/sql-2008-reporting-services-i-have-no-rights .

Basically, you will encounter this problem with UAC, if your only rights are exercised through the built-in \ adimistrators group, so that the windows "see" you need to run it with a boost, if you added your Windows account explicitly as the core content everything would be fine, as you discovered.

This behavior will be the same for a SQL server accessing through SSMS, where the only access was granted by the built-in \ Admiistrators, and not your user account explicitly.

Answer 3

This sounds suspicious because the account you use to access Report Manager does not have permissions to view the content. Depending on how you have the settings, it may not be enough to be a local administrator to see the contents.

On the Report Manager home page, try clicking the Properties tab and clicking Assign New Role and manually add your username and assign it to all available roles.

If this does not work, you may need to log into the Report Server through SQL Server Management Studio and double-check how the security system is configured. Make sure that you are connecting to the report server and not to the database engine.

Answer 4

You will also see this problem if you use the SSRS service under a domain account. In this case, you will see a completely blank page, regardless of whether you work as an administrator or not, but it will work in other browsers such as Firefox. This is a Kerberos authentication problem, there are several options for fixing it that are described in detail in this article .