Analysis Services in a mixed Novell/Windows environment

From: RaVaGe (RaVaGe_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 04:33:01 -0700

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: command line arguments like on mainframe under fujitsu
    ... then I think it is important that the workstation environment support ... It may or may not be worth adding here, that Fujitsu is RELATIVELY unusual ... to be "migration inhibitor" for some IBM mainframe COBOL customers. ...
    (comp.lang.cobol)
  • Re: [Full-Disclosure] RPC DCOM Patches
    ... I did with SP2 Servers and Workstation, the patch work fine and it did ... For your environment, better do it in a none production environment first, ...
    (Full-Disclosure)
  • Re: Analysis Services in a mixed Novell/Windows environment
    ... http-connection between client and server. ... > My customer has a combined Novell/Windows networking environment. ... None of the workstations is a member of the Windows Domain. ... > workstation and is passing that on to SQL Server/Analysis Services. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Services in a mixed Novell/Windows environment
    ... username as "domain\user" and pwd as the password. ... >> SQL BI Product Unit (Analysis Services) ... >>> My customer has a combined Novell/Windows networking environment. ... >>> workstation and is passing that on to SQL Server/Analysis Services. ...
    (microsoft.public.sqlserver.olap)
  • Re: How can i block users from accessing the internet?
    ... My customer would only like a single user to access the ... internet on this workstation. ... this workstation, the customer would like the internet to ...
    (microsoft.public.win2000.security)