SQL Server Performance Forum – Threads Archive

Install 2005 Reporting Service only?

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,

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.

Satya; Thanks so much for your recommendation!
George

]]>