SQL Server 2005 复制、事务性且可更新订阅错误
几天前，我为 SQL Server 2005 数据库设置了一些复制，复制类型是具有可更新订阅的事务型复制。
复制工作正常，最近我通过修改订阅者服务器上的 1 个数据来测试可升级订阅功能，但随后出现错误并且未提交数据。
错误是：
Error Source: .Net SQLClient Data Provider. Error Message: The RPC security information for Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable subscription: Rolling back transaction. ....
我已经检查了发布者和订阅者的用户名和密码，并且由于我使用混合身份验证并且我设置了相同的用户名和密码。 发布者和订阅者的密码不能错。
我的复制架构是这样的：
复制架构 http ://i.msdn.microsoft.com/ms151196.89217927-03fc-4ba0-8110-73ada9810b3f(en-us,SQL.100).gif
（使用3台服务器的左图），比方说A是发布者，B/C 是订阅者
有人有解决这个问题的办法吗？ 如果可能的话，我更喜欢 GUI 解决方案而不是 T-SQL。
Several days ago i setup some replication for our SQL Server 2005 database, the type of replication was a transactional with updateable subscription.
The replication are working fine, lately i test the upgradeable subscription feature by modifying 1 data on subscriber server but then the error was raise and data are not committed.
The error was:
Error Source: .Net SQLClient Data Provider. Error Message: The RPC security information for Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable subscription: Rolling back transaction. ....
I have check both publisher and subscriber username and password, and since i use mixed authentication and i have set the same username & password for publisher and subscriber it can't be wrong.
My replication schema was like this:
Replication schema http://i.msdn.microsoft.com/ms151196.89217927-03fc-4ba0-8110-73ada9810b3f(en-us,SQL.100).gif
(the left image which use 3 server), lets say A was publisher and B/C was subscriber
Anyone have a solution for this problem? I prefer a more GUI solution rather than T-SQL if possible.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
.gif){kind=link}
发布评论
评论（2）
抱歉，没有 GUI 解决方案，我将运行
sp_link_publication。此链接
http://msdn.microsoft.com/en-us/library/ms174991.aspx
解释参数
希望有帮助
Sorry no GUI solution, I would run
sp_link_publication.This link
http://msdn.microsoft.com/en-us/library/ms174991.aspx
Explains the parameters
Hope that helps
问题解决了，问题实际上与 MS DTC 相关，我修改了 MSDTC 设置并重新创建了复制（发布者和订阅者），现在可以工作了
PS：
- MSDTC 可以通过管理工具访问 -> 组件服务-> 右键单击计算机并转到 MSDTC 选项卡
- 就在那里，我检查所有项目并按“应用”，然后重新创建复制
The problem solved, the issues was in fact deals with MS DTC, i've modified MSDTC setting and recreate the replication (both publisher and subscriber) and now it's work
PS:
- MSDTC can be accessed on Administrative Tools -> Component Services -> Right click on Computer and go to MSDTC tab
- Right there i check all items and press Apply then recreate the replication