Help on Transaction Replication with Updating

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  June 16, 2011 at 9:33 am

  #239437

  Hi,

  I have been working on Transaction Replication with updating immediately for a week.

  When I try to update articles at Subscriber, I got the error message like below:

  Error message: The RPC security information for the Publisher is missing or invalid, use SP_link_publication to specify it.

  My environment as below,

  Publisher: Windows 2003, SQL server 2005 Enterprise Edition. Two nodes cluster with active/passive. DTC is enabled and MSDTC is configured.

  Instance Name: TestWhygh. MSdtc network name: MSDTCname

  Subscriber: Windows 2003, SQL server 2005 Enterprise Edition. Stand-alone server. DTC is enabled and MSDTC is configured.

  Instance name: whygh

  All the servers are in the same domain. I am using domain administrator to access.

  I used DTCPing on testwhygh and whygh, it succeeded on both direction.

  I executed sp_link_publication, commands completed successfully. However, I am still getting the same error.

  Sp_link_publication @publisher=’TestWhygh’,

  @Publisher_db=’AdventureWorks’,

  @Publication=”transactionReplWithUpdating”,

  @Security_mode=1,

  @login=’mydomain\administrator’,

  @password=’mypassword’,

  @Distributor=’TestWhygh’

  What else should I check?

  Thanks a lot!

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  June 17, 2011 at 8:01 am

  #1340447

  I deleted this replication and recreated from the scatch. It works now.