开发者

rpc security information for publisher is missing

i use sql server 2008 for publisher and sql server 2005 express for subscriber , when i insert to a table from my subscriber this error occur :

   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, Line 1
The transaction ended in the trigger. The batch has been aborted.

when insert to table from publisher all thing is ok .


Try creating the link on the subscriber. Run this on your 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}'
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜