Posted: 6/14/2012 9:37:25 AM
This the error message I am getting while setting up tran. replication from sql server agent job which has to copy the data to subscriber. The SQL server 2005 and sql agent is installed under 'Local System'.
2012-06-14 09:24:17.234 Connecting to Subscriber 'subscriber1'2012-06-14 09:24:17.250 Agent message code 20084. The process could not connect to Subscriber 'subscriber1'.2012-06-14 09:24:17.281 Category:NULLSource: Microsoft SQL Native ClientNumber: 18456Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Posted: 6/14/2012 11:46:09 AM
This error relates with the Login Credentails between the two server, add the user in the security server object
Posted: 6/15/2012 10:03:59 AM
Even after adding the login i am getting the error. Then I found out windows security mode is selected and I changed it to mix mode and it worked.