April 8, 2012 at 3:45 pm
Hi ,
I am trying to setup Transactional replication using pulling subscription between three servers( Server A, Server B, Server C ).
Server A and Server B are publishers. Server C is subscriber. I created two distribution databases on the Subscriber server C.
Server A contains two Publications and Server B contains three publications. All of these publications from the servers A and B are mapped to the subscribers on the server C.
I am able to setup Transactional replication using pull subscription between two publishers on the server A and two subscribers on the server C.
I am able to setup Transactional replication using pull subscription between two publishers on the server B and two subscribers on the server C.
when i am trying to setup replication using third publication which is located on the server B and subscription on the server C. I am getting the below error message when the distribution job is being run on the server C.
Unable to start execution of step 1 (reason: Error authenticating proxy Domain\SQLAgentuser , system error: Logon failure: unknown user name or bad password.). The step failed.
Can you please help me in fixing this issue.
Snapshot agent and log reader agent of the third publication are running on the server C without any issues.
All of the other Jobs are running with out any issues on the server C.
After doing some research i found the below link.
http://support.microsoft.com/kb/938086
The content in the link applies to SQL Server 2005 only.
I am running SQL Server 2008 r2 Enterprise edition 64 BIT on Windows server 2008 r2 ent edition 64 bit sp1.SQL Servers and windows server are of same editions on all of the three servers.
Thank You,
April 9, 2012 at 12:36 pm
Hi ,
I had fixed the issue.
Thank You,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply