Unable to connect to Analysis Manager through excel after applying ASSP3a

From: Rebecca Oh (anonymous_at_discussions.microsoft.com)
Date: 04/26/04 

Date: Sun, 25 Apr 2004 20:36:03 -0700

Hi,
Our SQL server had been installed with Service Pack 2 and with some hotfixes( The MDAC version was MDAC 2.7 SP1 Refresh. The new patch for MDAC is applied on server in January which was the last update to server. )

This server is used for OLAP purposes. User is using Excel to connect to Analysis Manager and retrieving the records from the Cube.

After installing the service Pack 3a, user was unable to connect to the server. A error message comes which includes MultiDimensional Connection Box Screen and message box

(screen name : open connection failed) ...

"Unable to open connection. Cannot Load databases;version may not be valid. Connection to the server is lost."

The above happens only if i use a user account. But using a administrator account I am able to connect. After trying many methods, uninstalled SQLServer and installed back SQL server with service Pack 2. Now i am able to retrieve the data from Cube as a user.

I need to patch Analysis Server with service pack 3a. Can the above situation be solved? Thanks in advance for any help regarding this...

Rebecca Oh

Relevant Pages

  • Unable to connect to analysis server after applying ASSP3a
    ... User is using Excel to connect to Analysis Manager and retrieving the records from the Cube. ... After installing the service Pack 3a, user was unable to connect to the server. ... "Unable to open connection. ...
    (microsoft.public.sqlserver.connect)
  • Failed to load cubes from Analysis Manager via Excel
    ... User is using Excel to connect to Analysis Manager and retrieving the records from the Cube. ... After installing the service Pack 3a, user was unable to connect to the server. ... "Unable to open connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Internet Connectivity Issues
    ... "Could not open connection to the host, ... When trying to RDP to the Server it just sorts of times out, ... If you were to ping the IP from the Internet ... I think that it might be a client PC or DOS attack since all of the above ...
    (microsoft.public.windows.server.sbs)
  • Re: HIV/AIDS - its evolution and possible effects on evolution.
    ... The ident service usually listens on port 113: ... Connecting To www.drdach.com...Could not open connection to the host, ... Why won't your server tell us you exist? ... the lowest life-form on the internet. ...
    (talk.origins)
  • RE: Could not open connection to the host, on port 143
    ... I could do "telnet machinename 143" from my PC to previous sever. ... machinename 143" from the server itself. ... Subject: Re: Could not open connection to the host, ... Are you using sendmail or postfix? ...
    (RedHat)