Re: Analysis Services in a mixed Novell/Windows environment

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 16:57:14 -0700

See the security configuration section in the SSAS Operations Guide:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx 

-- 
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.
"RaVaGe" <RaVaGe@discussions.microsoft.com> wrote in message
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

  • Issuing MDX query in Excel 2003,2007
    ... I have 2007 & 2003 versions of Excel. ... way to directly issue an MDX query against Analysis Services rather ... You can do this with SQL, ...
    (microsoft.public.sqlserver.olap)
  • Re: Help - "this recordset is not updatable"
    ... I have an MS-Access 2002 ADP application that connects to SQL server. ... displays "this recordset is not updatable". ... It does sound workstation related but still a security issue. ...
    (comp.databases.ms-access)
  • Printing Issue
    ... Workstation OS: XP Pro ... Network Printer: HP 4240n *have two of these printers ... month* Nothing installed- no changes beside a few MS critical updates in that ... most of the work that this person does is excel work. ...
    (microsoft.public.windows.server.networking)
  • 1.workstation disconnects from host 2.cant create Excel file
    ... the workstation disconnects from the host and both machines must ... It is only within this one proceedure that this occurs. ... The workstation is running Win 98 and the host is ... I installed my software on a "fresh" computer and then installed Excel ...
    (microsoft.public.vb.general.discussion)
  • Re: Unable to open entire project via ODBC to SQL server
    ... Failing a rights issue it looks like a corruption of some sort. ... SQL Server then open the .mpp file and re-save to SQL Server. ... It is something to do with the Workstation ID ... > the project database via MS-Project SaveAs can open it completely. ...
    (microsoft.public.project)