dbTalk Databases Forums  

Need help with connection

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


Discuss Need help with connection in the microsoft.public.sqlserver.olap forum.



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

Default Need help with connection - 05-15-2004 , 07:48 PM






I am unable to connect to the Analysis server through Excel, here is the information....


Server:
Windows 2000 Domain Controller (only server)
SQL Server 2000 SP3a applied
Analysis Server SP3a applied

------------------------------------------------------------------
Client 1:
Winodows XP Home
Excel 2003
PTSFull applied

Error:
Unable to open connection
Unspecified Error

------------------------------------------------------------------
Client 2:
Windows ME
Excel 2000 (SP3)
PTSFull applied


Error:
Unable to open connection
Cannot connect to server ... The server is either not started or busy.

(the server is started)

Any ideas?

Thanks in advance,
Fred


Reply With Quote
  #2  
Old   
Kyle L
 
Posts: n/a

Default Re: Need help with connection - 05-16-2004 , 01:20 PM






Check the cube security and check to see that the cube has been processed recently.


"Fred" <fakilby (AT) directvinternet (DOT) com> wrote

I am unable to connect to the Analysis server through Excel, here is the information....


Server:
Windows 2000 Domain Controller (only server)
SQL Server 2000 SP3a applied
Analysis Server SP3a applied

------------------------------------------------------------------
Client 1:
Winodows XP Home
Excel 2003
PTSFull applied

Error:
Unable to open connection
Unspecified Error

------------------------------------------------------------------
Client 2:
Windows ME
Excel 2000 (SP3)
PTSFull applied


Error:
Unable to open connection
Cannot connect to server ... The server is either not started or busy.

(the server is started)

Any ideas?

Thanks in advance,
Fred


Reply With Quote
  #3  
Old   
Fred
 
Posts: n/a

Default Re: Need help with connection - 05-16-2004 , 02:56 PM



did that already... I can't connect to the server, don't even reach the cubes
"Kyle L" <abuse (AT) hotmail (DOT) com> wrote

Check the cube security and check to see that the cube has been processed recently.


"Fred" <fakilby (AT) directvinternet (DOT) com> wrote

I am unable to connect to the Analysis server through Excel, here is the information....


Server:
Windows 2000 Domain Controller (only server)
SQL Server 2000 SP3a applied
Analysis Server SP3a applied

------------------------------------------------------------------
Client 1:
Winodows XP Home
Excel 2003
PTSFull applied

Error:
Unable to open connection
Unspecified Error

------------------------------------------------------------------
Client 2:
Windows ME
Excel 2000 (SP3)
PTSFull applied


Error:
Unable to open connection
Cannot connect to server ... The server is either not started or busy.

(the server is started)

Any ideas?

Thanks in advance,
Fred


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.