Yes it does.

"The test connection to linked server succeeded."

PS: It is now 22:30 here in South Africa. Keep posting, I'll help if you need me for anything in the...

Nope, it is possible

This is my setup:

Server 1 :

- SQL 2005 - Contains OLAP cube

Server 2 :

- SQL 2008 R2 (upgraded from 2005)

- Contains linked server pointing to Server...

Remember to also check that the settings are the same, not just in the linked server properties, but also for the provider. (Under Linked Servers > Providers > MSOLAP)...

I recreated the linked server.

I was just reading your post and error message again. I'm not sure that I understand exactly how your architecture fits together (i.e. db, web...

Michelle Mc Cabe (6/23/2010)

---

We have a similar issue.

We upgraded our development servers from 2005 t0 2008. The application server with the cubes still runns 2005. I installed the...

We have a similar issue.

We upgraded our development servers from 2005 t0 2008. The application server with the cubes still runns 2005. I installed the OLAP 9.0 provider....

I have also experienced cases where the exact same dynamic SQL query is much faster than the query referencing variables straight out.

As per Microsoft documentation, SQL was not intended as an object orientated programming language, it is a procedural system that stores and moves data.

Even though the Microsoft employee, whose name...