Problems with Reporting Services

Question

I am using SQLServer 2008 Enterprise Edition running in Windows 7 Home Premium Edition, and I am having problems with the reporting service. The Reporting Service Configuration Manager does not show neither the Report Service Web Server Url nor the Report Manager URL. However, if I bring closer the mouse to the place where the aforementioned Urls should be a tooltip with the value of these addresses appears.

Using this invisible url I go to Report Manager and it is empty in spite of the fact that I have made an apparent successful deploy of some reports from my Visual Studio 2008.

In addition, when attempting to see the reports through the Report Service Web URL it gives me the following error :

"The permissions granted to user yamil PC yamil ' plow insufficient for performing this operation. ( rsAccessDenied ) "

At last, no one of the web sites related with Reporting Services appears in the Internet Information Services Configuration Manager. Is this normal?

Answer 1

This looks like permission or UAC error to me. By default, BUILTIN\Administrators or the local admin group on computer would have content manager role on RS. If you are already part of this group and you still see the error, You need to right click on your IE's icon and "Run as Administrator" before you try to browse the Report Server URL which throws the error.

For Report Manager URL, if its greyed out, URL reservation for Report Manager is not done. See if Apply button is enabled, If it is, Clicking on the Apply button under Report Manager tab should take care of it.

Answer 2

Make sure the user you are trying to login with is an administrator. Once that is done you should be able to go into the report manager url as specified in Reporting Services Configuration Manager.