Home Forums SQL Server 2005 SS2K5 Replication The RPC security information for the Publisher is missing or invalid. RE: The RPC security information for the Publisher is missing or invalid.

  • January 16, 2009 at 10:53 am

    #928349

    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