Re: Logging on Olap from different domain

From: Gaute Bekeng (baldrick4_at_hotmail.com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 15:19:38 +0100

Thanks. I'll check this out.

Gaute
"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> skrev i melding
news:usKzOhwwEHA.3832@TK2MSFTNGP10.phx.gbl...
> This is discussed extensively in the SSAS Operations Guide:
>
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
> In the section titled: Security Administration
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jéjé" <willgart@BBBhotmailAAA.com> wrote in message
> news:uxKjJ7mwEHA.3832@TK2MSFTNGP10.phx.gbl...
> > you have 3 options:
> > * trust the domain (like you already have describe)
> > * create the same username / password on both domains
> > * use HTTP access (this required Enterprise edition of AS)
> >
> > Maybe, there is another solution:
> > the runas command line.
> > runas /user:domain\user /netonly excel.exe
> > this starts Excel and use the domain\user login when the user access
> remote
> > ressources. (not tested, but this works fine for other applications with
> the
> > same authentication problem)
> >
> >
> > "Gaute Bekeng" <baldrick4@hotmail.com> a écrit dans le message de news:
> > %23NufqdmwEHA.2908@tk2msftngp13.phx.gbl...
> > > Hi.
> > >
> > > We have a Olap server in a external domain. The users cannot access
the
> > > cubes if we have not created an user account with the same password on
> > > both
> > > domains. We have tried from Excel to speciy the external
domain\username
> > > when connecting to the analysis server, but we then get an error
message
> > > saying that Excel cannot access the databaseserver. If the passwords
are
> > > the
> > > same on both domains this works fine. Setting up a trust is not an
> > > option.
> > > We don't mind creating 2 user accounts but we would like to not having
> to
> > > manually update the password on the external domain everyother month.
> Does
> > > anyone know how to solve this? Thank you.
> > >
> > > Kind regards,
> > > Gaute B.
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Weird : More than the maximum of 64,000 dimension member
    ... > Program Manager ... > BI SystemsTeam ... > SQL BI Product Unit ... reprocessing the cube as I mentioned I am doing a incremental load ...
    (microsoft.public.sqlserver.olap)
  • Re: LogFile-Setting in the oqy-file dont work
    ... You looked on the client machine? ... Program Manager ... BI SystemsTeam ... SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
  • Re: PTS Version
    ... Natively on the service pack, the distribution files are located in the ... >> Program Manager ... >> BI SystemsTeam ... >> SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
  • Re: Virtual cube roles
    ... >> BI SystemsTeam ... >> SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection problems across domains
    ... > their sites with whatever domain controller they might have) can access ... >> Program Manager ... >> BI SystemsTeam ... >>> When I try and connect to a MSAS server in a workgroup it's fine, ...
    (microsoft.public.sqlserver.olap)