How to run Reporting Services 2000 and 2005 on the same server?
When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer.
Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume it is possible to install/manage Reporting Services as a windows services. Further dig out in Books online for SQL Server 2005 (May 2007 I think) and in this case you must have Windows Server 2003 operating system with SQL 2000 edition as a default instance and as usual SQL 2005 as a named instance. I would like to revisit what BOL updated there:
-
Verify that SQL Server 2000 Reporting Services is running as the default instance.
-
Run Setup for SQL Server 2005. When you use the SQL Server Installation Wizard, specify a unique instance name on the Instance Name page. When you run Setup from the command prompt, specify a unique instance name by using the instancename option.
-
Choose a files-only installation for the report server. Use the install but do not configure option in the Report Server Installation Options page in the SQL Server Installation Wizard or RSCONFIGURATION=filesonly in a command line installation.
-
Run the Reporting Services Configuration tool to deploy the new SQL Server 2005 instance. Choose a unique virtual directory for the report server and Report Manager. The names cannot be identical to those used in the SQL Server 2000 instance.
If everything is fine you will not hit with any errors while configuring the Reporting Services databases, ensure you have upto date service pack levels on SQL Server 2005 which is SP2. In this case you have to manually exeucte the rsconfig utility for the SQL 2000 RS instance. For that you have to run rsconfig to configure SSRS 2005, you have to refernce the one in the "C:\Program Files\Microsoft SQL Server\90\Tools\Binn" folder because the DOS PATH will likely use the 2000 version since it appears in the PATH before the new one. In any case before changing the default configuration for Reporting Services ensure you have a full database backup for system and RS system database as well.