We are going to upgrade our databases from SQLServer 2005 to SQLServer 2008 R2.
Today the databases including Reporting Services are running in SQLServer 2005 9.0.4211 and in a cluster environment.
We are planning
not to upgrade the Reporting Service database to Sqlserver 2008 R2. The Sqlserver2005 and Sqlserver2008 R2 will be run side-by-side.
My question is:
Is it possible to access a database running in Sqlserver 2008 R2 from a Reporting service database that is running in Sqlserver 2005 (9.0.4211)?
View Complete Post