How to get MS SQL 2005 reporting service

  • Hello,

    We decided to use MS SQL 2005 reporting services, once we upgrade our MS SQL 2000  SE to MS SQL 2005 SE. I can't find the 2005 reporting CD.

    It does not come with the original CD? Should I have to contact to MS to order it?

    MS says that we need to contact them to receive MS SQL 2000 reporting service CD. But what about SQL 2005 reporting service?

    When I install SQL 2005 express edition, the reporting service is there. But I don’t see reporting server service after installing SQL 2005 SE.

    I would really appreciate it if anyone advises me on this.

     

  • SQL 2005 Reporting Services is included in the normal SQL 2005 install media.

    When you do the SQL 2005 install, what do you see on the displays showing the System Configuration Check results, and the Components to Install.

    If you do not have IIS installed on the box, the config check will show a warning against 'IIS Feature Requirement' and the options for installing RS cannot be selected.  If you want RS on your box, you must also have IIS.

    Personally, I would prefer to put IIS and RS on a separate box to the database server.  The main DB server would host the RS databases, and RS is managed as any other client application.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Thank you so much for the kind answer!

Viewing 3 posts - 1 through 2 (of 2 total)

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