Post reply

SQL 2005 Transactional Replication to DB2

  • April 1, 2010 at 2:14 pm

    #386625

    We have setup transactional replication between SQL 2005 and DB2 tables.

    Password used to connect to subscriber had to be changed.

    This was done through the Subscription properties window in SQL management studio.

    Is there any other place where password for subscriber connection has to be updated?

    The reason i ask is, inspite of updating the new password on subscription properties window, distributor agent on SQL 2005 is unable to connect to the subscriber. Distributor agent is trying to connect to the subscriber using the old password.

    Any help would be appreciated.

    Thanks

    Prakash

    Prakash B

  • April 1, 2010 at 3:45 pm

    #1144513

    I found out the answer for the above issues. Thought will share it here:

    Other than updating the subscriber password on the subscription properties window in SQL Server, password had to be updated in table:MSdistribution_agents , column: SUBSCRIBER_PROVIDER_STRING.

    This holds good for non SQL server subscribers, especially DB2 subscriber.

    Prakash B

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply