Accessing Analysis Services 2000 Cube in SQL 2005 Management Studio

Can SQL 2005 Management Studio (using say, the Analysis Services MDX Query) make a connection to a Cube developed in SQL 2000's Analysis Server?

When SSMS tries to Connect to Analysis Services on the SQL 2000 server, I get the error "No connection could be made because the target machine actively refused it (System)"
CMGLAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
imran_fastConnect With a Mentor Commented:
you can connect to sql 2000 analysis server using sql 2005 studio it is just a matter of configuration

http://www.sqljunkies.com/WebLog/edwardm/
0
 
imran_fastCommented:
0
All Courses

From novice to tech pro — start learning today.