Prev: Cannot start device DCLoadBalancer
Next: SPS search error
From: Gunter Staes Gunter on 1 Aug 2006 09:53
I'm having the same problem. Thanks fo sharing any feedback with me.

"lvkam72" wrote:

> I have the same problem.
> Can anyone help?
>
> Thanks.
>
> "rbmanian" ha scritto:
>
> > I have created pivot table in excel 2007 connecting to a olap cube and
> > deployed it in the SPS 2007 with excel services running. when i try to access
> > the excel sheet using excel web access the sheet displayed as it is in when i
> > saved the excel sheet. but when i try to expand or collapse the tree in the
> > pivot table i get this error
> >
> > Data Refresh Failed
> >
> > Unable to retrieve external data for the following connections:
> >
> > [Date source name]
> >
> >
> > The data source may be unreachable, may not be responding, or has denied
> > access. The workbook location may also prevent data refresh.
> >
> > i have created the excel services auhtentcaion as windows authentication.
> > and the cube is accessible by everyone. is there any place i have to set the
> > authentication in sps apart from specifying at the time of publising the
> > excel sheet from excel 2007 to excel services.
> >
> >
> > Thank you
> >
> >
> >
From: marco.russo on 7 Aug 2006 05:28
You have to correctly configure Single Sign-On service (there is a
document in beta 1TR, "Configuring Single Sign On for Excel Services
B1" that explains that - please strictly follow instructions!).
I had to reinstall the whole Sharepoint making installation with a
domain admin account instead that with a local admin account. Otherwise
I get Single Sign-On service related errors on event log.

Hope it helps - I lost a day around it...

Marco

 | 
Pages: 1
Prev: Cannot start device DCLoadBalancer
Next: SPS search error