Getting Error while setting up tran. replication

Who is online?  90 guests and 0 members
home  »  forums   »  microsoft data platform   »  sql server & bi   » Getting Error while setting up tran. replication

Getting Error while setting up tran. replication

Topic RSS Feed

Posts under the topic: Getting Error while setting up tran. replication

Posted: 6/14/2012 9:37:25 AM

dahiya4u11
Deepak Dahiya
Lurker 4  points  Lurker
  • Joined on: 5/29/2012 12:45:10 PM
  • Posts: 2

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:NULL
Source:  Microsoft SQL Native Client
Number:  18456
Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Posted: 6/14/2012 11:46:09 AM

sqlservr
ramesh babu
Lurker 7  points  Lurker
  • Joined on: 5/17/2012 6:40:07 AM
  • Posts: 1

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

dahiya4u11
Deepak Dahiya
Lurker 4  points  Lurker
  • Joined on: 5/29/2012 12:45:10 PM
  • Posts: 2

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.
Page 1 of 1 (3 items)