dbTalk Databases Forums  

Error conecting OLAP Server with Excel AddInn

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


Discuss Error conecting OLAP Server with Excel AddInn in the microsoft.public.sqlserver.olap forum.



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

Default Error conecting OLAP Server with Excel AddInn - 09-06-2004 , 07:31 PM






I'm trying to use Excel as a front end for my cubes, but I can't connect with
my OLAP Server from a PC cients with Excel.

The server:
Windows 2000 server (SP4)
SQL Server 2000 (SP3)
Office XP Pro (SP3) with Excel Add In for SQL Server Analysis Services

The client:
Windows XP (SP1) (Home edition)
Office XP Pro (SP3) with Excel Add In for SQL Server Analysis Services

If I try to make the conection from the server's Excel I don't have any
problem, but when I try to make the conection from the client's Excel in the
Conection Manager window from Cube Analysis Menu, appears this error window:


OLAP Server Error trying to connect to "name server"
OLAP Server Error: Error no specified


I would apreciate any help

SergeD


Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Error conecting OLAP Server with Excel AddInn - 09-06-2004 , 07:45 PM






have you installed the Analysis Services SP3 client on the workstation?
search the file "ptslite.exe" in the SP3 package

"SerchD" <SerchD (AT) discussions (DOT) microsoft.com> a écrit dans le message de news:
B2BD04BB-C816-4915-B6B4-6557D138659D...soft (DOT) com...
Quote:
I'm trying to use Excel as a front end for my cubes, but I can't connect
with
my OLAP Server from a PC cients with Excel.

The server:
Windows 2000 server (SP4)
SQL Server 2000 (SP3)
Office XP Pro (SP3) with Excel Add In for SQL Server Analysis Services

The client:
Windows XP (SP1) (Home edition)
Office XP Pro (SP3) with Excel Add In for SQL Server Analysis Services

If I try to make the conection from the server's Excel I don't have any
problem, but when I try to make the conection from the client's Excel in
the
Conection Manager window from Cube Analysis Menu, appears this error
window:


OLAP Server Error trying to connect to "name server"
OLAP Server Error: Error no specified


I would apreciate any help

SergeD




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.