Thursday, March 22, 2012

32 bit BI-tool connecting a 64 bit SQL Server 2005

Hi,

I have Cognos 8 as BI-tool installed on a Windows 2003 Server, both 32 bit. We are thinking of using a 64 bit SQL Server 2005 with 64 bit Windows 2003 Server as database server for a new data warehouse.

Can I use the 32 bit SQL Native Client on the Cognos server for connecting to the 64 bit database server? If not, how should I set this up?

Thanks in advance for your help.

Kind regards,

Albert de Ruiter.

The communication channel between SQL Client and SQL server is independent of CPU arch on either side. There are should be no problem connecting each other. You just connect to the server as usual, as if you don't know the server is 64bit. Please let us know if you have issue.|||Thank you!

No comments:

Post a Comment