System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction

System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction

Resolution:-

Add a link to the publisher server on the subscriber database for the updatable subscription (transactional replication).

USE <Subscriber DB>

GO

EXEC sp_link_publication
@publisher = ‘<publisher Server>’,
@publication = ‘xxxxx publication Name’,
@publisher_db = ‘<Publisher DB>’,
@security_mode = 0,
@login = ‘<remot login>’,
@password = ‘<remote login password>’;

This entry was posted in Replication, SQL Server, Troubleshooting and tagged , , , . Bookmark the permalink.

Leave a Reply