Re: URGENT: distribution agent failure: NT AUTHORITY\ANONYMOUS LOGON

From: JJ Wang (anonymous_at_discussions.microsoft.com)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 14:55:45 -0800

thanks Hilary.

builtin\administrators is part of our system
administrators role. and our sql servers are running
under their own domain account which is also system admin
role on the servers.

the wierd thing is that only this one publication is
failing, rest of the publications from the same server are
working fine.

JJ

>-----Original Message-----
>Is builtin\administrators part of your system
administrators role? It sounds
>like someone has removed this group.
>
>What account is your SQL Server running under as well?
>
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>"JJ Wang" <anonymous@discussions.microsoft.com> wrote in
message
>news:259601c4e95f$785ef330$a401280a@phx.gbl...
>> hi,
>>
>> I am working on sql server 2000 replication. One of our
>> sql servers has multipul publications that push out to
>> several subscribers, and some of the subscribers are the
>> database on the same publisher server. and I've
>> encountered the following failures with only one of its
>> publications. This particular publication is from one
>> database push to another database on this same publisher
>> server. And we have a seperate server to act as
>> distributor for all server's replications:
>>
>> ----------
>> Executed as user: domain_name\distributor_server_name.
>> Replication-Replication Distribution Subsystem: agent
>> distribution_agent_name failed. Login failed for
user 'NT
>> AUTHORITY\ANONYMOUS LOGON'. The process could not
connect
>> to Distributor 'distributor_server_name'. The step
failed.
>> ----------
>>
>> I've verified all login configurations on the publisher
>> and subscriber (in this case, they are of the same
>> server), and the distributor. All correct.
>>
>> what process/agent's logon account is this error
complaint
>> about (user 'NT AUTHORITY\ANONYMOUS LOGON')?
>>
>> many thanks!!
>>
>> JJ
>
>
>.
>

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)