Re: NT Authorization\Anonyomous logon error
From: pat (pat_at_discussions.microsoft.com)
Date: 09/24/04
- Previous message: Deepak Puri: "Re: MDX : quering distinct property values."
- In reply to: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Next in thread: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Reply: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 11:23:04 -0700
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.
>
>
>
- Previous message: Deepak Puri: "Re: MDX : quering distinct property values."
- In reply to: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Next in thread: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Reply: Dave Wickert [MSFT]: "Re: NT Authorization\Anonyomous logon error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|