Posted - 01/02/2013 : 01:33:39
The scenario is as follows:
Currently, we have a BI Application called "Sapience" which uses 32-bit version of XML/A to be connected to OLAP. We are using SQL Server Analysis Services 2000 right now.
Now we are planning to move to a complete 64-bit architecture and moving to SQL Server 2005. We have already tried it on our test server, however, the problem we are facing right now is that our 32-bit XML/A is not able to connect to 64-bit SSAS (OLAP).
Is there any way around this problem?
Will SQL Server 2005 Backwards Compatibility tools help? If yes, then please specify how.
Should we go for any third-party tools? If yes, then please provide the link here.
A swift and sincere help will greatly oblige. In real need of a solution.