Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Running SSRS 2000 having ReportServer database on

Author  Topic  Atifkh74 Starting Member 1 Post Posted - 2011-04-28 : 08:30:27 Dears, I have SQL Server Reporting services 2000 installed on my web server. This web server connects to my DB Server which is running on SQL Server 2000 having ReportServer and ReportServerTempDB on it. Now we are planning to upgrade our DB Server to SQL Server 2008 (64 bit). I just want to confirm that anyone has tried this before that Reporting Services 2000 are installed at web server having Windows Server 2003 and SQL Server 2000 and the ReportServer DB is located at a remote machine on SQL Server 2008 (64 bit). The steps I've tried so far: 1. Moved the ReportServer and ReportServerTemp DB to SQL Server 2008 from SQL Server 2000. 2. Ran rsconfig -c –s<Remote ServerName> -dReportServer -aSQL –u<uid> –p<pass> on my web Server. Now when I try to open http://localhost/Reports the following error appears: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.9.45'. The expected version is 'C.0.6.54'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) Get Online Help Any ideas? Regards -Atif