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
 Development Tools
 Reporting Services Development
 Upgrade to SQL Server Reporting Services 2005

Author  Topic 

Krb_iiaba
Starting Member

16 Posts

Posted - 2006-07-25 : 11:55:12
We just rolled out 64bit SQL Server 2005 on a 64bit Server 2003 OS. We have 2 webservers that have the Reporting Services 2005 installation (each web server running 32bit 2003 OS hence 32bit version of 2005 Reporting Services).

On each web server, we go through the 'Configure Report Server' utility and recieve an error on the Database Setup step as follows:

The database version (C.0.8.43) does not match your Reporting Services installation. This version of the database cannot be upgraded. You must use a different database.

Also, when attempting to visit the Reports virtual directory on each web server we recieve the following error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.


However, we installed the Reporting Services 2005 64bit version on the SQL Server itself and everything works fine. Question is:

Does the 32bit version of RS work with 64bit SQL Server 2005? If so, what could be wrong with the configuration of RS on our webservers?

tfinch
Starting Member

1 Post

Posted - 2006-11-06 : 17:04:51
Hi,

I'm having the same issue with my ReportServer database sitting on a 64-bit SQL server and a new SSRS install residing on a 32-bit web box. Did you ever get this resolved?

Thanks!
Go to Top of Page

cori
Starting Member

1 Post

Posted - 2007-01-23 : 17:28:17
I had the same problem in a very similar configuration (1 64-bit sql server, 1 32-bit report/web server, both on virtual machines).

Turns out I hadn't upgraded Reporting Services on the web server to SP1. Once I did so it worked like a charm.
Go to Top of Page
   

- Advertisement -