Thursday, June 5, 2008

Sql Server 2000 Reporting Services (SSRS) LogonUser Problem

We recently had an issue where we had set up a new server for a customer due to a problem with their older server. It is running some older stuff: Sql Server 2000 as well as the associated Sql Server 2000 Reporting Services, it also has all of the latest SPs installed. When we set up the user that SSRS would use to connect to the Reporting Service database we must have typed a password in incorrectly and were getting the following error in the event log and could not connect to the http://localhost/Reports website.

Event Type: Error
Event Source: Schedule and Delivery Processor
Event Category: Management
Event ID: 129
Date: 6/5/2008
Time: 12:16:29 PM
User: N/A
Computer: SERVER
The encrypted value for LogonUser in the RSReportServer.config file cannot be decrypted.

After some looking around we found a simple solution to our problem. It essentially resets the database user to the information provided. Be cautious however because it could cause problems with existing data. Since we don't use subscriptions or any other data and deploy from the development environment on another server it was not an issues for us.
C:\>rskeymgmt -d
All data will be lost. Are you sure you want to delete all encrypted data from
the report server database (Y/N)? Y

The command completed successfully

C:\>rsconfig -c -s %computername% -d ReportServer -a Windows -u DOMAIN\user -t
The command completed successfully

C:\>rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
The command completed successfully
Best wishes on resolving any issues you might be having.

No comments: