Running into an issue with a dimension...we have 1 table thats on 1 server joining to another table on another server. We need to build a dimension off 1 table and include an attribute from the other table.
When we do this we get an error that says "SQLCNI10.1" is not registered. This join works fine until we include a column from the second table into the dimension.
The first table is on a 2008 instance and the second table is on a 2005 instance. What I am guessing its doing is going to the 2005 server and using a remote query to get to the 2008 server.
I think the fix is to install the 2008 native client on the 2005 server...but is there any other way around this?
View Complete Post