Problem with updatable subscriptions replication

• hcaldwell

  Grasshopper

  Points: 16

  More actions

  June 4, 2008 at 7:54 am

  #183046

  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

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 4, 2008 at 12:17 pm

  #824415

  Did you try:

  http://support.microsoft.com/kb/320773 ?

  
  * Noel

• hcaldwell

  Grasshopper

  Points: 16

  More actions

  June 4, 2008 at 3:07 pm

  #824549

  Thanks that fixed it. I had actually visited that page a while ago but I was still dealing with firewall issues at the time.

  What a relief!

  -Hugh

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 4, 2008 at 3:33 pm

  #824570

  Cool. Glad you got it working!

  
  * Noel