Friday, March 23, 2012

Reporting Services (SSRS)

Hey everyone...I'm completely new to SQL Server and I'm trying to learn the Reporting Services tool. I just installed SQL Server 2005 and selected to install all the options, atleast I'm 99.99% sure I did.

When I go to launch Report Services Configuration, I get "No report servers were found on the specified machine. Details: Invalid namespace". Do I need IIS for this to work?

Also, I do not think the AdventureWorks database was installed, I cannot seem to find it anywhere. I have tried to go back through and reinstall it, but it says that it is already installed.

Also, is there a certain order that you are supposed to install things? i.e. SQL Server before Visual Studios?

Thanks in advance.

*Edit* BTW, I'm using Windows XP, SQL Server Enterprise Edition, and VS.NET 2005.YOu definetly need IIS to host Reporting Services. If you did not install that prior to the installation of Reporting Services / SQL Server 2005, the installer skipped the Reporting Services (server) part, although you might activated a "full installation". But at the beginning of the setup there should have been a warning at the prerequisites pages telling you that server components of Reporting Services will not be installed due to the lack of IIS.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Do I have to again uninstall SQL Server 2005 and install it again or I coan now configure it to run RS?|||

Actually no. You will have to

-install IIS on your computer
-Register ASP.NET on the IIS instance again using aspnet_regiis -i on the commandline.
-Install Reporting Services
-Done.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment