Problem with Transactional publication with updatable subscription replication

Question

I'm trying to setup transactional replication between two servers which are not in AD. I can make changes at the publisher which show up at the subscriber but when I make a change in the data at the subscriber I get the following error;

 

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.

 

I've run the sp_link_publication command on the subscriber with the information for the sa account as well as the sqlagent account with no noticeable effect. Both server have an identical sqlagent account to run the Sql Server Agent service.

 

I've used DTCPing and DTCTester from both servers succesfully.

 

There are no errors in the logs.

 

Any help would be greatly appreciated.

 

Thanks,

Hugh

 

 

Answer 1

I'm having the same issues on 2 non AD servers. Have you made any recent progress on the issue. I've been at it for a couple days now with no luck.

Any update would be great.

Thanks

Larry

 

 

Answer 2

I am also having this problem. I am using a transactional replication with updateable subscription. The procedure is executed at the subscriber and having the same error below. This was running before and suddenly its not working. No updates has been made.

Msg 21079, Level 16, State 1, Procedure sp_getpublisherlink, Line 52
The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
Msg 20512, Level 16, State 1, Procedure sp_MSreplraiserror, Line 8
Updateable Subscriptions: Rolling back transaction.
Msg 3609, Level 16, State 1, Procedure spSetMyVehiclesReq, Line 28
The transaction ended in the trigger. The batch has been aborted.

---

Luanne