Re: Login failed for user 'NT AUTHORITY\ANONYMOUS '

If the MSDE box where the job is located is running under
the local system account then you won't be able to import
from a different server. The local system account does not
have access to network resources including other servers.

-Sue

On Wed, 4 May 2005 14:14:55 -0400, "Alan Z. Scharf"
<ascharf@xxxxxxxxxxxxxx> wrote:

>
>Getting error below when try to run inport job automatically.
>
>Job saved in MSDE on WinXP box.
>Importing from SQL2000 on Win2000 Server.
>
>I can execute the job manually OK.
>
>SQLAgent on importing MSDE logging on as system account.
>
>Any help would be appreciated.
>
>Thanks.
>
>Alan
>
>--------------------------------------------------------
>Step Error Source: Microsoft Data Transformation Services (DTS) Package
>Step Error Description:Unable to connect to source server for Transfer.
>(Microsoft SQL-DMO (ODBC SQLState: 28000) (80004005): [Microsoft][ODBC SQL
>Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
>LOGON'.)
>Step Error code: 80040443
>Step Error Help File:sqldts80.hlp
>Step Error Help Context ID:5700
>
>

.

Relevant Pages

  • Re: Login failed for user NT AUTHORITYANONYMOUS
    ... > the local system account then you won't be able to import ... >>Job saved in MSDE on WinXP box. ... >>Step Error Description:Unable to connect to source server for Transfer. ... >>Step Error Help File:sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: AT Scheduler WinAT.exe
    ... I want to run the task using the local System account therefore I need to ... use AT as the Scheduled Tasks Wizard does not allow use of the local ... Is the 'WinAT.exe' utility approved on Windows Server 2003? ...
    (microsoft.public.windows.server.general)
  • Re: Synchronization with AD Project 2003
    ... Sorry - I'm running my AD sync tests on the AD server... ... > Does the local system account need access to AD? ... > The error message in event viewer is as follows.. ...
    (microsoft.public.project.pro_and_server)
  • Service will not stay started under system account.
    ... I have a server that has 2 MQ listener services that worked fine under ... the local system account, but now will only stay started for a few ... All other services using system account are ...
    (microsoft.public.win2000.general)
  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)