April 14, 2010 at 8:53 am
Folks:
We are planning to upgrade our Reporting Services from SQL 2005 32 bit to SQL 2008 64 bit. Question is: After the migration to SQL 2008 64 bit, will my Reporting services be able to pull data from SQL 2005 databases which will be on 32 bit?????
Thanks !
April 14, 2010 at 9:01 am
Yes. the file formats, protocols, access is the same between 32 bit and 64 bit.
April 19, 2010 at 7:29 am
How about Reporting services on SQL Server 2005 32 bit be able to pull data from SQL Server 2008 64 bit databases?
April 20, 2010 at 7:03 am
SSRS of any version can pull data from SQL Server DB of any version. 32-bit and 64-bit makes no difference.
You may have problems if you want to use data types that are not known in an older version of SSRS, but if you only use data types common to both versions of SQL Server then should be no problems.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply