Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The RPC security information for the Publisher is missing or invalid. Expand / Collapse
Author
Message
Posted Wednesday, November 5, 2008 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 28, 2009 3:52 AM
Points: 8, Visits: 20
I have created Transaction-updatable replication between two databases in sqlserver 2005. At the subscriber end if i make any changes i get the following error while saving changes made to the table.

No row was updated
The data in row 1 was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
Updateable Subscriptions: Rolling back transaction.
The transaction ended in the trigger. The batch has been aborted.

Please provide help.
Post #597224
Posted Friday, January 16, 2009 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 2, 2009 7:08 AM
Points: 2, Visits: 6
Exactly the same problme here. If I find a fix I'll let you know.
Post #638039
Posted Friday, January 16, 2009 10:53 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
n_padma (11/5/2008)
I have created Transaction-updatable replication between two databases in sqlserver 2005. At the subscriber end if i make any changes i get the following error while saving changes made to the table.

No row was updated
The data in row 1 was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
Updateable Subscriptions: Rolling back transaction.
The transaction ended in the trigger. The batch has been aborted.

Please provide help.



Have you ran sp_link_publication in the subscriber database?

sp_link_publication @publisher = '{publisher instance name}'
, @publisher_db = '{published database name}'
, @publication = '{publication name}'
, @security_mode = '1'
, @login = '{sql server login account to connect publisher}'
, @password = '{password}'
, @distributor = '{distributor instance name}'




* Noel
Post #638315
Posted Friday, January 16, 2009 11:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 2, 2009 7:08 AM
Points: 2, Visits: 6
Hi,

I did but the syntax I deduced from the ms web site was a bit different.

I’ll try your syntax on Monday.

Thanks a lot and have a great weekend.

Paul
Post #638356
Posted Friday, January 16, 2009 1:22 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
Good Luck


* Noel
Post #638478
Posted Friday, March 27, 2009 5:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 72, Visits: 251
The sp_link_publication did not work.

I have changed the options in security configuration of MSDTC section of the component services to 'allow remote administration' and 'allow inbound' and 'allow outbound' under transaction manager communication.

This setup is on a two node cluster. Do I have to restart the servers after making this change or I should be restarting the MSDTC resource alone?
Post #684896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse