SQL Server Performance

Install 2005 Reporting Service only?

Discussion in 'SQL Server 2005 Reporting Services' started by georgej, Apr 23, 2007.

  1. georgej New Member

    I want to use the features of SQL Server 2005 Reporting Service.
    Can I only install SQL 2005 Reporting Service component on my existing server which already has SQl server 2000 installed? So I can use 2005 Reporting Service new features by accessing to my SQL 2000 database.


    Thanks for suggestions,


  2. satya Moderator

    SQL Server Reporting Service is installed from the SQL Server media. Have IIS (Internet Information Server) preinstalled and running prior to setting up Reporting Services. If IIS is not running, you may receive the error 1603 during the SSRS setup. In addition, have the service DTS (Distributed Transaction Service) running and configured to run at startup. This can be done from the Windows Services applet. Next, during SQL setup from the SQL 2005 CD, check the Reporting Services option during the Component Install section.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. georgej New Member

    Satya;

    Thanks so much for your recommendation!


    George

Share This Page