Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2003-12-15 : 15:29:38
|
| I have a pull subscription setup from one server to another. I get this message in the Job History when running the agent...Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Why is it attempting to logon with this user? I have the security setting to impersonate the SQL Server Agent account. Under teh SQL Agent properties I have "Use System Account" enabled on both the subscriber/publisher. When I setup a pull subscription on the same server as the publisher/distributor, I do not have this problem.I get the same error when attempting a push subscription the other server on th subscription login step.I am logged into windows with the same domain sysadmin password. This account is in the publication access list, and has access to the distribution database.Distributor login does not fail if I set the agent to login as sa user. |
|
|
|
|
|
Cannot connect to distributor