Solved

Accessing Analysis Services 2000 Cube in SQL 2005 Management Studio

Posted on 2007-03-20
2
491 Views
Last Modified: 2008-02-01
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)"
0
Comment
Question by:CMGL
  • 2
2 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 18755351
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 18755361
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored procedure 4 35
Grid querry results 41 80
display data in text field from data base for updating 6 65
Are triggers slow? 7 10
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question