Friday, March 23, 2012

Installing SQL Server Reporting Services

Hi All,

I have just installed SQL Server Reporting Services and done the settings on Reporting Services Configuration.

The Server Status is 'green ticked' and it is Running, the Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity and Database Setup are all setup and 'green ticked'

But when I go to the Reports in IE:http://localhost/Reports I get the following error:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

I have googled this but do not seems to have a suitable solution for me. Please help.

Thanks in advanced.

Hi,

From the error message you provided, do you run your Reporting Service on Vista?

Since Reporting Services SP1 and earlier do not run on Windows Vista, you need to install SP2 for reporting service.

If you try to run an SP1 report server on Windows Vista, you will encounter the following errors:

If you open this SP1 application:You will see this:Report Manager or report server, just after upgrading but before ASP.NET is enabled or IIS is startedInternet Explorer cannot display the webpage.Most likely causes:Reporting Services Configuration toolAn unknown error has occurred in the WMI provider. Error Code 8000000AReport ManagerThe report server is not responding. Verify that the report server is running and can be accessed from this computer.Report ServerThe report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)For more information about this error navigate to the report server on the local server machine, or enable remote errors.

For more information, see http://technet.microsoft.com/en-us/library/ms156468.aspx Thanks.


|||

Hi,

Thanks for the comment. I have actually solved the problem now.

First: Stop Reporting Services

Second: Restart IIS

Third: Start Reporting Services

Then try browsinghttp://localhost/reports and it worked.

Cheers.

No comments:

Post a Comment