Re: NT Authorization\Anonyomous logon error

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

Date: Fri, 24 Sep 2004 14:48:24 -0700

Administration and querying requires a common domain between machines; you
cannot use workgroups. There are some workarounds that you can look at --
they are discussed in the security section of the AS Operations Guide, see:
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.
"pat" <pat@discussions.microsoft.com> wrote in message
news:998C5B6A-7E68-40EF-882B-C5584271442D@microsoft.com...
> You are correct both servers are in the same workgroup on a network but
not
> appart of the network.  My problem is how do I give the anonymous account
> enough rights on the sql box to let it process the cube or is this a
> possible.  What I am doing now is creating a CAB file coping to the IIS
box
> and restoring the data base.  This works but takes time.
>
> Any better ideas????
>
> "Dave Wickert [MSFT]" wrote:
>
> > My guess is that you don't have a common domain between machines; if one
> > doesn't exist then the system uses the anonymous account.
> > -- 
> > 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.
> >
> > "pat" <pat@discussions.microsoft.com> wrote in message
> > news:A5562733-F562-40D7-9228-E2ED3E90E796@microsoft.com...
> > > I have a SQL box and a IIS server. On the IIS box I have istalled
Analysis
> > > Server and have place several cube that I wish client to access via a
VPN
> > > connection and a web application.  When I try to reporcess the cube I
get
> > an
> > > NT Authorization error.  I can build the cube on the IIS server but
not
> > > process it.  Any ideas on how to fix the authorization error without
> > opening
> > > up the SQL box to the world?  The SQL box is Windows 2000 server and
the
> > IIS
> > > is Windows 2003 web version.  SQL and Analysis servers are both 2000
with
> > the
> > > latest patches installed.
> >
> >
> >

Relevant Pages

  • Re: NT AuthorizationAnonyomous logon error
    ... SQL BI Product Unit ... > Server and have place several cube that I wish client to access via a VPN ... I can build the cube on the IIS server but not ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection error when accessing OLAP
    ... There is a proxy server between the users and the IIS server. ... If the cube is opened and the excel file saved and sent and opened on ... what is the content of the IIS log file? ...
    (microsoft.public.sqlserver.olap)
  • Re: Connection error when accessing OLAP
    ... what is the content of the IIS log file? ... do you have a proxy server between the users and the IIS server? ... Some of the users are receiving this error when aaccessing the Cube from ...
    (microsoft.public.sqlserver.olap)
  • NT AuthorizationAnonyomous logon error
    ... I have a SQL box and a IIS server. ... Server and have place several cube that I wish client to access via a VPN ...
    (microsoft.public.sqlserver.olap)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)