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:
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
FileName
-pStrongPassword
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 /?
- 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:
- 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
-dreportDatabaseName
-a Sql|Windows -uuserAccount
-puserAccountPassword
Note For more information about the rsconfig command-line utility, run the following command at the command prompt:
RSConfig /?
- 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
-pStrongPassword
FileName
andStrongPassword
with the file name and the password that you used to back up the symmetric encryption keys in step 2. - Restart your computer.
- 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:
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