June 16, 2011 at 9:33 am
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!
June 17, 2011 at 8:01 am
I deleted this replication and recreated from the scatch. It works now.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply