Re: Connection to Server Failed - Analysis Services

Tech-Archive recommends: Fix windows errors by optimizing your registry

No, I mean, is the actual Analysis Services Service running on the machine?

To start Microsoft® SQL Server™ 2000 Analysis Services, follow these steps:

Open Control Panel.


If your computer's operating system is Windows® 2000, open the Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT® 4.0, double-click Services.

Select MSSQLServerOLAPService, and then on the Action menu click Start.




Simon Worth

Raj C. wrote:
If you mean did we launch Analysis Manager on the local machine - than yes. But for some unknown reason, we can't register the local server but we can register a remote server on the network. FYI - Our login name is a member of the OLAP admin group.

Please HELP!
Raj C.

"Simon Worth" wrote:


Is the Analysis services service started on the local machine?

Simon Worth

Raj C. wrote:

Hi,
For some unknown reason, we are getting the following "Connection to Server Failed" error message when we attempt to register our local server using MS Analysis Services:

"Errors occurred while connecting to '<localservername>'. Cannot open connection to Analysis server '<localservername>'. Cannot connect to the server '<localservername>'. The server is either not started or too busy. Do you still want to register the server?

Please note that we are running the Developer versions of MS SQL Server 2000 and MS Analysis Services with SP3 installed for both components on Windows XP Professional.

Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using Analysis Manager, but we aren't able to either register or connect to a local server because we get the message above.

We are uttterly confused by this error message and would GREATLY APPRECIATE any help in resolving this confusing issue as soon as possible.

Thanks,
Raj C.


.

Relevant Pages

  • Re: Find AD hostname from Linux command line
    ... The Windows XP workstation gets an IP ... "Register this connection's addresses in DNS" turned ON. ... If I am on a Linux server and do "ping lancelot.ad.mydomain.com", ...
    (microsoft.public.win2000.dns)
  • Problem manually registering dll files using REGSVR32
    ... I am having an issue with a terminal server. ... I have the "Error message 5 ... The Oledb32.dll file is not upgraded when you upgrade your operating system ... from Windows 2000 to Windows Server 2003 ...
    (microsoft.public.windows.terminal_services)
  • Re: Dual Boot
    ... when I boot into windows Home edition; I see disk 0 The Maxtor ... the MBR Disk 1 is F: and E: with xp Home, E: has the operating system on it ... Now when I boot into Server 2003, I see Disk 0 J: and K: server ...
    (microsoft.public.windows.server.general)
  • Re: NTLOADER IS MISSING
    ... operating system drive. ... reboot the server and it came up. ... then loads windows from the operating system partition becuase my ...
    (microsoft.public.windows.server.sbs)
  • Re: Multihomed Domain Controller Setup
    ... > I recently upgraded my domain from Windows 2000 Active Directory to ... > Should I not use the second NICs and connect all DCs to live subnets ... Uncheck "Register this connection" under IP properties, ... In the DNS console, right click the server name, choose properties, then ...
    (microsoft.public.windows.server.active_directory)