Post reply

The RPC security information for the Publisher is missing or invalid

  • July 20, 2011 at 3:52 am

    #241678

    Hi All,

    Cany any body please help me to reslove the below replication error.

    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 uspCS_AssignContentwithDueDate, Line 98

    The transaction ended in the trigger. The batch has been aborted.

    Thanks & Regards

    Deepak

  • July 20, 2011 at 12:17 pm

    #1355930

    Seems like the Link server is not getting created. Try running the below

    sp_link_publication @publisher = 'Publisher Instane name'

    , @publisher_db = 'name of DB Published'

    , @publication = 'name of Publication'

    , @security_mode = '1'

    , @login = 'Account used to connect to Pub'

    , @password = 'Pass word used'

    , @distributor = 'Instance name of the Dist'

    I once had a problem like this in my QA and I ran this to fix it

    -Roy

  • July 20, 2011 at 10:46 pm

    #1356144

    Hi Roy,

    Thanks for your reply, yes it is the problem with Linked server and but now my concern is why it was missed out in the replication set up , i mean while creating the publication ?

    - Deepak

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply