Friday, November 14, 2008

An internal error occurred on the report server.

Problem Description:
=======================================================================
Older 2000 server and wanting to move reporting services to SQL 2005
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Key not valid for use in specified state.

Steps:
=======================================================================

1. From Explorer, navigate to x:\Documents and Settings\\Application Data\Microsoft\Crypto\RSA\S-1-5-20. In this case, the folder was C:\Documents and Settings\NetworkService\Application Data\Microsoft\Crypto\RSA\S-1-5-20.

2. Search for files with the pattern "1aedd7b5699f3d6a88e354100b596aae_*". These files represent the Microsoft SQL Server Reporting Services Key Container.
3. Delete these files.

Removing encrypted content, reconfiguring the SQL Server login account, and activating the report server:
rskeymgmt.exe -d
rsconfig.exe -e -s -d -a Windows -u -p -t
now restarted the service

Browsed the reports it works fine.

Restored the backup DB of reportserver and reportservertempdb on the dc02 box

Now pointed the reports to fetch the data from the DC02 Machine using the below command.

rsconfig -c -m -s -d reportserver -a SQL -u SA -p

Resolution:
=======================================================================
Now able to browse the reports after success fully migrating from 2000 to 2005.

No comments: