Adding SQL Reporting Services to SQL Server 2005 SP1

I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases:

! Verifing Database Version

The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database.

! Creating upgrade script for database version C.0.8.40

ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(String databaseName, String serverVersion, String& script)

I've reinstalled the entire SQL Server 2005 installation. As part of company installation precodure, SQL 2005 w/o Reporting Services is installed first, followed by SP1. I then perform the SQL Reporting Services installation add-on.

Thanks,

Mark

Ditto. I'm having the same issue. Another wrinkle (or red herring) is that I changed the name of the server before installing SP1 and before installing Reporting Services.|||I get the same too. This is a fresh intall of SQL 2005. What gives!|||

Found the answer :)

Just install SQL 2005 SP1 again (after you installed Reports Services). Fixed it for me.

Good luck

|||

That may do it as well. I re-installed SQL Server because I believe the issue was that I had the retail version of SQL 2005 installed and was trying to install the Developer Edition of SQL 2005 Reporting Services on that. I got a vague warning about the versions not matching, but matching the version of SQL 2005 between the database engine and the reporting services fixed the issue. I still need to install SP1 again....

|||

Yes. Reapplying SP1 after the Reporting Services install fixed the problem. Once SP1 is applied, run the Reporting Services Configuration Tool and the older database format will be converted.

- Thanks for the help.

|||

Hello,

I am receiving the error, "creating upgrade script for database version c.0.8.40" as well. I've tried everything I know of and it still doesn't work. I've uninstalled SQL Reporting Services, reinstalled, then reapplied SP1 but it still doesn't work. I've tried changing the application app pool for reporting services, that didn't work. I've also traced the process with file mon, that didn't help (saw a post on that somewhere else).

Can anyone help me? Is there a utility to check the health of reporting services maybe?

Thanks,
Bob

|||

I can't remember how I solved the issue now (a while ago)

possibly the worst case, uninstall everything and re-install everything

With SP2 officially out, you might want to try upgrade everything (RS, SQL) to SP2 then

|||

Hi Bob,

Try installing SQL server SP2,this should be working.

i did the same and lol its as working fine

Thanks,

vvbkumar