FIX: You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services

Article translations Article translations
Article ID: 956138 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.
Expand all | Collapse all

SYMPTOMS

You cannot upgrade a non-English version of Microsoft SQL Server 2000 Service Pack 4 (SP4) together with Microsoft SQL Server 2000 Reporting Services Service Pack 2 (SP2) to Microsoft SQL Server 2008 Reporting Services.

This problem affects the upgrade of only the non-English version of SQL Server 2000 Reporting Services.

CAUSE

This problem occurs because SQL Server Setup does not select the instance of Reporting Services when you upgrade to SQL Server 2008 by using the SQL Server Installation Wizard or by using the command prompt. The Setup program code cannot detect the instance of Reporting Services when you upgrade a non-English version of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services.

RESOLUTION

The fix for this problem was first released in Cumulative Update 1. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
956717 Cumulative update package 1 for SQL Server 2008
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
956909 The SQL Server 2008 builds that were released after SQL Server 2008 was released

Steps to resolve this problem

  1. On the computer that is running SQL Server 2000 SP4 together with SQL Server 2000 Reporting Services SP2, apply Cumulative Update 1.
  2. Upgrade to SQL Server 2008 Reporting Services.
The Setup program can now detect the instance of Reporting Services when you upgrade a non-English version of SQL Server 2000 Reporting Services.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
955392 How to update the SQL Server 2008 Setup program by using SQLSupport.msi

WORKAROUND

To resolve this problem, migrate the Reporting Services data instead of upgrading SQL Server 2000 Reporting Services. To do this, follow these steps:
  1. Back up the data before you migrate the data. To do this, follow these steps:
    1. To back up the Reporting Services key, run the following command:
      rskeymgnt.exe –e –I <InstanceName> –f <Path>\key.txt -p <Password> -t
    2. Back up the Reporting Services databases. For example, back up the reportserver database and the reportserverTempDB database.
  2. Upgrade SQL Server 2000 to SQL Server 2008.
  3. Disable the instance of SQL Server 2000 Reporting Services. To do this, follow these steps:
    1. In Internet Information Services (IIS), disable the URLs for Report Server and for Report Manager.
    2. Disable the SQL Server 2000 Reporting Services service.
  4. Add an instance of SQL Server 2008 Reporting Services by using the files-only mode.
  5. Migrate the Reporting Services configuration settings from SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services. To do this, follow these steps:
    1. Open Reporting Services Configuration Manager.
    2. Create a Report Server URL. For example, create the following URL:
      http://<ComputerName>/reportserver
    3. Create a Report Manager URL. For example, create the following URL:
      http://<ComputerName>/reports
    4. Set the instance of SQL Server 2008 Reporting Services to point to the SQL Server 2000 Reporting Services databases.
    5. In Reporting Services Configuration Manager, apply any other Reporting Services settings that are needed. For example, apply the e-mail delivery settings.
    6. Open the Reporting Services configuration file to reconfigure the Reporting Services settings. For example, apply the SQL Server 2000 Reporting Services settings to the SQL Server 2008 Reporting Services configuration file. Apply the file share setting, the e-mail extension setting, and the Report Server URL setting.
  6. Start the SQL Server 2008 Reporting Services service.
  7. Apply the Reporting Services key if you changed the instance name. For example, run the following command:
    rskeymgnt.exe –a –i <InstanceName> –f <Path>\key.txt -p <Password> -t
  8. Examine the existing reports and the existing subscriptions.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about what files are changed, and for information about any prerequisites to apply the cumulative update package that contains the hotfix that is described in this Microsoft Knowledge Base article, click the following article number to view the article in the Microsoft Knowledge Base:
956717 Cumulative update package 1 for SQL Server 2008

REFERENCES

For more information about the list of builds that are available after the release of SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
956909 The SQL Server 2008 builds that were released after SQL Server 2008 was released
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499 New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 956138 - Last Review: March 19, 2009 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2000 Reporting Services Service Pack 2
Keywords: 
sql2008relnotereportingservices sql2008relnoteconfiguration sql2008relnotereadfirst sql2008relnote kbtshoot kbpubtypekc kbprb KB956138

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com