Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Client Connections to Analysis Services

Author  Topic 

r_shankar_ganesh
Starting Member

2 Posts

Posted - 2002-04-23 : 23:30:04
Hi
I have developed analytical cubes in SQL Server 2000 Analysis services in my windows 2000 server machine. I have used Pivot table list (as HTML files and excel pivot table) in Office XP as front ends for this cubes. Everything is working well in my machine (windows 2000 Server).
But when I try to access this pivot table list from my client machines (Windows XP home edition with Office XP), I couldnot do so. When I try to drill down or select the combo boxes in the pivot table list from my client machine, it tries to connect to the server but could not do so. Our networking setup is a simple workgroup setup with a single server and a client machine. Both are under the same workgroup.
Advance thanks for your help.

Regards
Shankar

mprabha1
Starting Member

5 Posts

Posted - 2002-05-02 : 02:40:19
Hi Shankar,

This is the same problem i'm facing but..for me it works well when the client is well within the same domain..but when it is from a diff domain or workgroup...i have problems accessing the analysis server...will u pls let u know if u have got any solutions...there is a solution specified in msdn...u can search for it as "How to configure Analysis Services for the web"...but even after doing it...it has now solved my problem..

prabhakar

Go to Top of Page
   

- Advertisement -