具有可更新订户错误的事务复制 [英] Transactional Replication with Updatable Subscribers Error

问题描述

我正在尝试在两个不同的服务器之间用可更新的订户实现事务复制.

DB_P是Server1上的发布者数据库.
DB_S1是Server2上的订户数据库.
DB_S2是Server1上的订户数据库.
DB_S3是Server2上的订户数据库.

SQLSERVER服务被启用为NETWORKSERVICE.两台服务器上均启用了MSDTC.通过DTCPing检查了RPC调用.

设置分发服务器，发布服务器和订阅服务器之后，当我在与发布服务器数据库(DB_P)位于同一服务器上的订阅数据库(DB_S2)上执行sp_link_publication语句时，它工作正常.
但是，当我在Server2上存在Subscription数据库(DB_S1和DB_S3)上执行sp_link_publication语句时，出现以下错误:

链接服务器"REPLLINK_SERVER1 \ -1468339317_PEGASUS2_A-1570475579_DBPUP369101659_DB_S-1726189269"的OLE DB提供程序"SQLNCLI10"返回了消息没有事务处于活动状态.".
消息7391，第16级，状态2，第1行
无法执行该操作，因为链接服务器"REPLLINK_SERVER1 \ -1468339317_PEGASUS2_A-1570475579_DBPUP369101659_DB_C-1726189269"的OLE DB提供程序"SQLNCLI10"无法开始分布式事务.

I am trying to implement Transactional Replication with Updatable Subscribers across two different Servers.

DB_P is the Publisher database on Server1.
DB_S1 is the Subscriber database on Server2.
DB_S2 is the Subscriber database on Server1.
DB_S3 is the Subscriber database on Server2.

SQLSERVER services are enabled as NETWORKSERVICE. MSDTC is enabled on both servers. Checked RPC call via DTCPing.

After setting up Distributor, Publisher and Subscriber, when I execute sp_link_publication statement on the Subscription database (DB_S2) which is on same Server as of Publisher database (DB_P), it works fine.
But when I execute sp_link_publication statement on the Subscription database (DB_S1 and DB_S3) exists on Server2 it gives me the following error:

OLE DB provider "SQLNCLI10" for linked server "REPLLINK_SERVER1\-1468339317_PEGASUS2_A-1570475579_DBPUP369101659_DB_S-1726189269" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "REPLLINK_SERVER1\-1468339317_PEGASUS2_A-1570475579_DBPUP369101659_DB_C-1726189269" was unable to begin a distributed transaction.

推荐答案

我用您的错误消息的最后一部分作为搜索词并用此 [

I googled using the last part of your error message as the search phrase and this[^] was one of the hits.

Hope it helps. :)

这篇关于具有可更新订户错误的事务复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！