Installing Reporting Services on SQL Server 2005.

  • Hi,

    I am a new SQL Server 2005 DBA.

    We have SQL Server 2005 (SP1) on our servers.

    I have to do the following:

    1. Install SQL Server Reporting Services.

    2. Install SP3 of SQL Server 2005.

    First I went to the Server and checked all the services that were running. I found that SQL Server Reporting Services (MSSQLSERVER) is running on the Server. Then I checked all the databases that were installed. I did NOT find the two databases installed for Reporting Server. These are: ReportServer and ReportServerTempDB.

    My questions:

    1. What is happening here? How could the Reporting Services be running but Reporting Server databases not be installed. Why are the two Reporting Server databases not created? What should I do to install Reporting Server? Put in the Reporting Server DVD and just run? (Of course, I will do this during off hours)? Any tips or pointers. Any help appreciated.

    2. Installing SP3. Should I first install Reporting Server and then SP3. Or does the order of install matter?

    Once again, any help appreciated.

  • To run SSRS 2005 in production SP2 is required and I don't think SSRS is running because you need those two databases to render you RDL(report definition language). So you need to apply SP3 and rerun step and repair SSRS make sure your IIS is installed and configured.

    Kind regards,
    Gift Peddie

  • You may have installed the SSRS but you need to configure it if you did not pick "Install but do not configure" during the installation. Take a look at this:

    http://msdn.microsoft.com/en-us/library/ms159624(SQL.90).aspx for configuring SSRS.

    -GW

  • most likey that during the SSRS configuration the databases were installed to another server.

    open Reporting Services configuration on the server and click on "Database Setup". The "Server Name" option will show where the databases are installed to 😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply