dbTalk Databases Forums  

Getting error message when trying to connect to AS 2000 server from SQL Server 2005 Management Studio

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


Discuss Getting error message when trying to connect to AS 2000 server from SQL Server 2005 Management Studio in the microsoft.public.sqlserver.olap forum.



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

Default Getting error message when trying to connect to AS 2000 server from SQL Server 2005 Management Studio - 09-06-2006 , 06:06 PM






Here's what I get:
*******************************
Cannot connect to servername.
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)
*******************************

On the same client, I can connect to an instance of AS 2005 on the
server. I can also connect to the AS 2000 instance via the AS 2000
Analysis Manager tool.

However, I'd like to be able to connect to the AS 2000 instance via SQL
Server 2005 Management Studio.

Anyone have any ideas?

Thanks,
Sylvia


Reply With Quote
  #2  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Getting error message when trying to connect to AS 2000 server from SQL Server 2005 Management Studio - 09-06-2006 , 10:02 PM






This is not supported. You cannot manage or query AS 2000 servers using
SSMS -- you must continue to use Analysis Manager for management of AS 2000
servers.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Sylvia" <Puget4753 (AT) yahoo (DOT) com> wrote

Quote:
Here's what I get:
*******************************
Cannot connect to servername.
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)
*******************************

On the same client, I can connect to an instance of AS 2005 on the
server. I can also connect to the AS 2000 instance via the AS 2000
Analysis Manager tool.

However, I'd like to be able to connect to the AS 2000 instance via SQL
Server 2005 Management Studio.

Anyone have any ideas?

Thanks,
Sylvia




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.