Upgrading Reporting Services

SQL Server 2008 supports upgrading from the following earlier editions of Reporting Services:

• SQL Server 2000 Reporting Services with Service Pack 2 (SP2)

• SQL Server 2005 Reporting Services

You can choose to perform an in-place upgrade or migrate a Reporting Services Installation to SQL Server 2008. You can run the Upgrade Advisor tool on the Report Server computer to determine any issues that might prevent a successful upgrade. Known upgrade issues currently include the following:

• There is no upgrade support for a Report Server that uses a remote SQL Server 2000 Database Engine instance to host the Report Server database.

• There is no support for the SQL Server 2000 Report Server Web service in SQL Server ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.