Microsoft KB Archive/840714

= &quot;This edition of the Reporting Server Database is not supported on the edition of SQL Server 2000 you have chosen&quot; 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:  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. 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  -p

Note By default, the rskeymgmt command-line utility is located in the :\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 /?

 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

 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: <ol style="list-style-type: lower-alpha;"> 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  -d   -a Sql|Windows -u   -p

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

RSConfig /?

</li> 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  -p

Note Replace  and   with the file name and the password that you used to back up the symmetric encryption keys in step 2.</li> Restart your computer.</li></ol> </li></ol>

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  -d reportserver -a Windows &quot;NT AUTHORITY\SYSTEM&quot;

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.

<div class="references_section">