Monday, August 10, 2009

Reporting Services ---- error - No report servers are found on the specified system.

The follow error occurs when you try to configure reporting services.

Error - No report servers are found on the specified system.

Check the following

1. Reporting services is installed.
2. If installed make sure the services is started in --- start --- administrative tools --- services
3. If reporting services is not installed possible readon IIS is not installed or installed partially not all components.

For Reporting Services, the following IIS components should be installed:
Web Management Tools
IIS 6 Management Compatibility
IIS 6 WMI Compatibility
IIS Metabase and IIS 6 configuration compatibility
World Wide Web Services
Application Development
.NET Extensibility
ASP.NET
ISAPI Extensions
ISAPI Filters
Common HTTP Features
Default Document
Directory Browsing
HTTP Redirection
Static Content
Security
Windows Authentication

Make sure the above IIS componenents are installed.

For windows server 2008 --- click start --- server manager --Roles --- add roles --- click IIS and follow the steps and guidelines.
If IIS is already installed then click on (Web server)IIS --- go to role services ---add role services --- select components to install and follow the guidelines.

After this successful installation of IIS. Go to control panel --- programs --- programs and features --- click on sql server 2005 --- change --- and point to the setup.exe file from the sql server CD, and install reporting services.

No comments:

Post a Comment