dbTalk Databases Forums  

Can SQL 2005 Managment Studio connect to AS 2000 Databases?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Can SQL 2005 Managment Studio connect to AS 2000 Databases? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ricardo Sada
 
Posts: n/a

Default Can SQL 2005 Managment Studio connect to AS 2000 Databases? - 08-04-2005 , 12:28 PM






Hi,

Can SQL 2005 Managment Studio connect to AS 2000 Databases?

Ive been trying to do so in order to try some MDX queries but no luck so
far.. I get the following error.

TITLE: Connect to Analysis Services
----------------------------------------
Cannot connect to rsada.
----------------------------------------
ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)

----------------------------------------
No connection could be made because the target machine actively refused
it (System)
----------------------------------------
BUTTONS:
OK
----------------------------------------

The service is running. Ive both SQL2000 and SQL2005 in my computer with
2005 as a named instance..

Thanks a lot

Ricardo Sada

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Can SQL 2005 Managment Studio connect to AS 2000 Databases? - 08-05-2005 , 01:39 AM






Sorry. I don't believe we support that. SQL RDBMS does, but I don't think we
do in the AS side.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Ricardo Sada" <rsada (AT) solcominter (DOT) com> wrote

Quote:
Hi,

Can SQL 2005 Managment Studio connect to AS 2000 Databases?

Ive been trying to do so in order to try some MDX queries but no luck so
far.. I get the following error.

TITLE: Connect to Analysis Services
----------------------------------------
Cannot connect to rsada.
----------------------------------------
ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)

----------------------------------------
No connection could be made because the target machine actively refused it
(System)
----------------------------------------
BUTTONS:
OK
----------------------------------------

The service is running. Ive both SQL2000 and SQL2005 in my computer with
2005 as a named instance..

Thanks a lot

Ricardo Sada



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.