Re: Data Refresh Failed - Office 2007- Excel services

Yes. You need Kerberos or SSO.

-Sean

"GSwan" <GSwan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FD359CBD-60EA-43C3-BC57-6520FDECA54F@xxxxxxxxxxxxxxxx
OK. I find myself finally stumbling across a post that might be of help. I'm
having exactly the same problem and am trying to use Windows authentication.
Is it really the case that you have to use SSO to get this to work? Or is
there a way to use windows authentication? I had an authentication issue a
few months back with an ASP.net app i was writing to communicate with a SQL
server. I couldn't get windows authentication working between servers. It was
suggested that Kerberos delegation was the way to get around this. It sounds
as though this may be required here. Can anyone confirm or deny this?

Thanks,

Grant

"madhur" wrote:

Hello

I am using Windows Authentication with everything installed on a single
box
infact a VPC. Can you point me a link for the configuration of kerberos
in sharepoint.

Thanks

Madhur
http://madhurahuja.blogspot.com

Sean Boon [MSFT] wrote:
> You need to use SSO or configure Kerberos. The other option is to put
> everything on the same box and then you can use Windows auth. You > cannot
> use SQL authentication with Analysis Services. We are working on a
> whitepaper for this topic. I'll see if we can get an early version of > it
> posted here.
>
> Sean
>
> -Sean
> "madhur" <ahuja.madhur@xxxxxxxxx> wrote in message
> news:1163969111.062733.114380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello
> >
> > I am having the same problem. Is SSO the only solution to this > > problem.
> > I am connecting
> > SQL 2005 cube using Windows Authentication. It works fine in client > > but
> > fails in browser.
> > If I use SQL authentication, can It be a workaround for SSO ?
> >
> > Madhur
> >
> > SHW wrote:
> >> I had the same problem and finally the only way I could get it to > >> work
> >> was to
> >> trun SSO on. After that everything worked fine. Here is what you > >> need to
> >> do:
> >> 1. Turn SSO on in SharePoint. It creates a database in SQL server to
> >> store
> >> user names and passwords.
> >> 2. Define an Enterprise Application: This really means you are > >> defining a
> >> user name and password and giving it a name. For example the user > >> name
> >> can be
> >> a domain account that can connect to SSAS over the network. You give > >> it a
> >> password that is saved encrypted in the database and you give it a > >> name
> >> for
> >> the Enterprise Applicatin like MYBI.
> >> 3. In the Excel book, you modify the connection to use SSO and under > >> the
> >> SSO
> >> account name you put MYBI.
> >>
> >> Here is a link for more information:
> >> http://technet2.microsoft.com/Office/en-us/library/3c78e886-5d20-44cb-b4e4-f823c4c019281033.mspx?mfr=true
> >>
> >> Hope this helps. It took me a long time to figure this out.
> >>
> >> SHW
> >>
> >> "Mike L" wrote:
> >>
> >> > Marco,
> >> > I have read your note that you have suceeded in configuring Single
> >> > Sign-on
> >> > to enable Excel Services to open an external data connection to > >> > SSAS
> >> > 2005. I
> >> > cannot find the document that you reference in Beta 1 TR (maybe it > >> > has
> >> > been
> >> > deleted for Beta 2 TR). I have spent over a week with the same > >> > error
> >> > so any
> >> > advice would help.
> >> > For example what was the "Application Name" you used for SSAS > >> > 2005?
> >> > --
> >> > Mike L
> >> >
> >> >
> >> > "marco.russo@xxxxxxxxx" wrote:
> >> >
> >> > > 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
> >> > >
> >> > >
> >



.

Relevant Pages

  • Re: Data Refresh Failed - Office 2007- Excel services
    ... I am using Windows Authentication with everything installed on a single ... can It be a workaround for SSO? ... I have read your note that you have suceeded in configuring Single ... domain admin account instead that with a local admin account. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Data Refresh Failed - Office 2007- Excel services
    ... I'm desperately trying to make "Excel Services + OLAP cube" work with SSO on ... rights in SQL) for the SSOsrv, the SSO admin account, the MOSS farm admin,... ... I couldn't get windows authentication working between servers. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Data Refresh Failed - Office 2007- Excel services
    ... the data connection, specify the connection type as None and specify ... having exactly the same problem and am trying to use Windows authentication. ... Is it really the case that you have to use SSO to get this to work? ... few months back with an ASP.net app i was writing to communicate with a SQL ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Data Refresh Failed - Office 2007- Excel services
    ... having exactly the same problem and am trying to use Windows authentication. ... Is it really the case that you have to use SSO to get this to work? ... few months back with an ASP.net app i was writing to communicate with a SQL ... domain admin account instead that with a local admin account. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SSO
    ... and can use the Kerberos in Active Directory. ... Apache can use mod_auth_kerb that supports SPNEGO. ... When trying to determine the right SSO solution for your web ...
    (comp.protocols.kerberos)