I am trying to connect to an Analysis Services 2000 server (running SP4)
using SQL Management Studio (2005). However, when I try to connect to it, I
get "No connection could be made because the target machine actively refused
it". The account that I am using is in the Administators and OLAP
Administrators groups on the server, and the 2000 Analysis Manager works
fine on the same client to the same server running under the same account.

Does SQL Management Studio simply not work with AS 2000? Or is there
something else that needs to be done to make it work?

Thanks,
Rick

Sorry. Unfortunately it doesn't. SSMS manages RDBMS instances for both 2K
and 2K5, but only Analysis Services 2K5 instances. If you want to manage the
older AS2K servers, then you need to have Analysis Manager..
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Rick Razzano" <rick.razzano (AT) gmail (DOT) com> wrote