Microsoft KB Archive/840714

From BetaArchive Wiki
Knowledge Base


"This edition of the Reporting Server Database is not supported on the edition of SQL Server 2000 you have chosen" error message when you try to install the Report Server database on an instance of SQL Server 2000 64-bit

Article ID: 840714

Article Last Modified on 7/18/2005



APPLIES TO

  • Microsoft SQL Server 2000 Reporting Services
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2000 Enterprise Edition



Bug #: 144405 (SQL BU Defect Tracking)


SYMPTOMS

When you install Microsoft SQL Server 2000 Reporting Services Enterprise Edition on your computer, if you try to install the Report Server database on an instance of Microsoft SQL Server 2000 Enterprise Edition 64-bit, the installation may not continue and you may receive the following error message:


This edition of the Reporting Server Database is not supported on the edition of SQL Server 2000 you have chosen, Please choose another SQL Server that matches the requirements.

WORKAROUND

To work around this problem, follow these steps:

  1. Install Microsoft SQL Server 2000 Reporting Services Enterprise Edition on your computer by installing the Report Server database on an instance of Microsoft SQL Server 2000 Enterprise Edition 32-bit.
  2. On the computer that has the SQL Server 2000 Reporting Services installed, use the rskeymgmt command-line utility to back up the symmetric encryption keys. To do this, run the following command at the command prompt:

    RSKeyMgmt.exe -e -f FileName -p StrongPassword

    Note By default, the rskeymgmt command-line utility is located in the InstallationDrive:\Program Files\Microsoft SQL Server\80\Tools\Binn folder. For more information about the rskeymgmt command-line utility, run the following command at the command prompt:

    RSKeyMgmt /?

  3. Move the Report Server database and the Report Server temporary database from the instance of SQL Server 2000 32-bit to your instance of SQL Server 2000 64-bit.

    Note By default, the following databases are the Report Server database and the Report Server temporary database:
    • ReportServer
    • ReportServerTempDB

    For more information about how to move the databases, click the following article number to view the article in the Microsoft Knowledge Base:

    314546 How to move databases between computers that are running SQL Server

  4. On the computer that has the SQL Server 2000 Reporting Services installed, configure the report server instance to use the Report Server database that is moved to your instance of SQL Server 2000 64-bit. To do this, follow these steps:
    1. Use the Rsconfig.exe command-line utility to configure the Report Server instance to use the correct Report Server database. To do this, run the following command at the command prompt:

      RSConfig -c -s serverName -d reportDatabaseName -a Sql|Windows -u userAccount -p userAccountPassword

      Note For more information about the rsconfig command-line utility, run the following command at the command prompt:

      RSConfig /?

    2. On the computer that has the SQL Server 2000 Reporting Services installed, use the rskeymgmt command-line utility to apply the keys that you backed up in step 2. To do this, run the following command at the command prompt:

      RSKeyMgmt -a -f FileName -p StrongPassword

      Note Replace FileName and StrongPassword with the file name and the password that you used to back up the symmetric encryption keys in step 2.
    3. Restart your computer.

The following example shows how to configure a Report Server to use a built-in account when you connect to a local Report Server database:

rsconfig -c -s SQLSERVERNAME -d reportserver -a Windows "NT AUTHORITY\SYSTEM"


Note Notice that -u is not used. Examples of supported built-in account values include NT AUTHORITY\SYSTEM for Local System and NT AUTHORITY\NETWORKSERVICE for Network Service for Microsoft Windows Server 2003 only.

REFERENCES

For more information about how to install or to upgrade reporting services, click the following article numbers to view the articles in the Microsoft Knowledge Base:

836064 How to upgrade from Reporting Services Beta 2 to Reporting Services and preserve the existing data and the key


For more information, click the following article number to view the article in the Microsoft Knowledge Base:

832976 Microsoft SQL Server 2000 Reporting Services Readme additions



Additional query words: fails

Keywords: kberrmsg kbdatabase kbsetup kbprb kbconfig KB840714