Re: Analysis Services in a mixed Novell/Windows environment

From: Matthias (matthiasenglert_at_nospam_hotmail.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 15:52:49 +0200

Hi,

to work with AS in a "domain free" environment, you have to use an
http-connection between client and server. In this case you can connect to
the server using windows authetification, the IIS-anonymous account or
defining individual users, passed through using basic authentification in
IIS for the file msolap.asp

cheers,
Matthias

"RaVaGe" <RaVaGe@discussions.microsoft.com> schrieb im Newsbeitrag
news:70D6245D-6EDE-45A3-90B0-7E98A1EFB70A@microsoft.com...
> Hi
>
> I have a serious issue that I would like some help with.
>
> My customer has a combined Novell/Windows networking environment. Through
a
> set of tools both environments are kept in sync as far as users and
passwords
> are concerned. None of the workstations is a member of the Windows Domain.
>
> The customer's workstations are all logging into the Novell environment.
> When I try to connect to an Analysis Cube (SQL Server 2000/Analysis
Services
> Standard Edition SP3a) from Excel 2000 using a pivottable I get an error
> message saying that authentication is not possible.
>
> In fact I presume that Excel is picking up the User ID and Password from
the
> workstation and is passing that on to SQL Server/Analysis Services. Since
the
> Userdomain of the workstation is the workstation itself this seems to go
> wrong. When I make the workstation a member of the windows Domain it works
> fine. However, this is not really an option for the customer.
>
> I there any way to get this to work? Can I have Excel prompt me for the
> userid, password and Domain? Or is there a workaround? Or any other
solution
> or remark?
>
> Thanks
>
> Ralf
>
>
>

Relevant Pages

  • Re: Network Problem
    ... And be aware it is a BAD idea to have a machine acting as server and ... workstation even in a p to p environment. ... you to dedicate a machine to host the data and NOT be a workstation. ...
    (comp.databases.paradox)
  • RE: workstation and server CLR kernel
    ... try using the COMPLUS_BuildFlavor environment ... This will load the server GC ... rather than the workstation GC. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Re-Post - "the trust relationship between this workstation and
    ... There were no logged events in either the DC or workstation. ... DC/DNS Server - DCDiag ... Attr: subschemaSubentry ... only problem is adding a new user account on the station. ...
    (microsoft.public.windows.server.active_directory)
  • trust relationship between workstation and the primary domain fail
    ... When I am at a workstation attached to the domain and try to add a local ... Server: server1.contoso.org ... Testing LDAP servers in Domain contoso ... ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.general)
  • RE: Slow Logon related to groups
    ... Open Server Management console on SBS ... Ensure the problematic user has permission to access its home folder on ... After the problematic user logon workstation, ...
    (microsoft.public.windows.server.sbs)
Loading