Login failed for user... -- sql server connect

Brett
7/7/2003 7:42:15 AM

I'm trying to set up a subscription from a transactional
publication. The publication works find but when I try to
push or pull a subscription to another server I get the
following message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I can set up a subscription on the publishing server
without an problems, but the two servers don't want to
communicate with each other. Any help would be greatly
appreciated.

Thanks,

Sethu Srinivasan [MSFT]
7/7/2003 4:22:22 PM

Hi Brett,
Please make sure SQLAgent service is running under a valid domain account
that has access to remote servers

Thanks
sethu

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server connect : Login failed for user...