Login failed for user 'NT Authority\Anonymous

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elpepe - 11 Apr 2005 15:37 GMT

I have a Merge Replication configuration in which one Publisher replicates
with 20 subscribers.

Currently, we use Windows Integrated security.

I get the following error when attempting to access tables in a remote
server from the publisher.

In Query Analyzer window, logged into publisher, I type

SELECT * FROM <subscriber1>.<databasename>..<tablename>

And get the following error message:

Login failed for user 'NTAUTHORITY\ANONYMOUS LOGON'

1) From everything I’ve read, including article 827422, it is necessary to
go to Mixed Security in order to overcome this security issue. Is this true?

2) Will changing the security mode on the Publisher and all 20 subscribers
cause any problems with replication?

Reply to this Message

Donna Lambert - 22 Apr 2005 21:35 GMT

1) That's a major over-generalization to say that changing it to SQL
Authentication (Mixed Mode) will allow you to over come this. It's working
around the issue entirely. You will still have issues with Windows
authentication, and should deal with those.

When you set up the merge subscribers, are they anonymous? Did you specify
for the merge agent to connect to the subscriber (if push) or publisher (if
pull) under the credentials of the SQL Agent account? What is that account?
Can you log onto each server (pub and sub) as their respective SQL Agent
accounts, then try to open Query Analyzer and point to the other server using
windows authentication? Do you get the same "Anonymous error"? Are they the
same account? If not, are they in the same domain? Make sure they both have
the correct rights to each other's machine. If not in the same domain, you
need to look at trust issues. If there is no trust, then you will either
have to set one up, or use mixed mode and SQL accounts.

2) No, unless you consider the time to restart SQL an issue.

Donna Lambert

> I have a Merge Replication configuration in which one Publisher replicates
> with 20 subscribers.
[quoted text clipped - 17 lines]
> 2) Will changing the security mode on the Publisher and all 20 subscribers
> cause any problems with replication?

Reply to this Message