Re: NT Authorization\Anonyomous logon error

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: pat (pat_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 15:49:05 -0700

Thanks for the link. I will check it out -- looks like a work around in the
security section. I will read tonight.

Thanks again.

Pat
"Dave Wickert [MSFT]" wrote:

> 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: RPC Scan Issues
    ... set the feature to download and reboot the machine at anytime. ... running as a local service it has admin rights. ... suggestions to automate patching in the meantime (network in the thousands ... Better Management for Network Security ...
    (Focus-Microsoft)
  • Re: Granting all users Admin Rights
    ... I am responsible for the upkeep and security of 50 ... > Standard users can do everything they need without admin ... >>I am currently the network manager at a small college ... >>rights on their machines. ...
    (microsoft.public.win2000.security)
  • Re: Read Only Access to ADUC
    ... I have to review user accounts for correct rights and privilages and access ... >> to have admin rights on the network. ... > overall security posture of the infrastructure ...
    (microsoft.public.security)
  • What is SUPPORT_388945a0?
    ... This entry is in security ... computer from the network." ... my workstation from a laptop, ... I do not have rights to ...
    (microsoft.public.windowsxp.security_admin)
  • SecurityFocus Microsoft Newsletter #50
    ... Subject: SecurityFocus Microsoft Newsletter #50 ... Specialist in Microsoft's Security Services Partner Program, ... Network Monitoring for Intrusion Detection ... Relevant URL: ...
    (Focus-Microsoft)