sql server reporting services: invalid report server database -- sql server reporting services

invalid report server database

DLS
12/22/2005 10:01:02 PM

sql server reporting services:

I'm trying to install the developer edition of SQL Reporting Services in a
developer edition of SQL 2000. I keep getting the error message
"rsInvalidReportServerDatabase" and the expected version is 'C.0.6.54'. I do
a complete uninstall, manually remove the database and log files, and attempt
another install, but keep getting an error that I need to run rsactivate.
When I do I get the error that the Report Web service has not generated a
public key. I unchecked the require SSL during install. When I run the report
manager I get the invalid report server database. Any help will be

Re: invalid report server database

Dan Slaby
12/23/2005 5:40:47 PM

The problem is that I changed the name of the machine and needed to update
Security with the SQL logon of the new <local machine>\ASPNET account and
set the database access for Master, ReportServer, ReportServerTempDB to
RSExecRole. If anyone gets this same error, you may want to check your
ASPNET logon in SQL server.

Dan

[quoted text, click to view]