具有订阅的事务发布不起作用。 [英] Transaction Publication with subscriptions is not working.
问题描述
我正在尝试使用使用订阅进行交易复制来复制数据。
我已根据此链接完成了所有流程
https://www.youtube.com/watch?v=rPs8FV5lHEM
但数据没有被复制到另一个SQL Server实例。
当我检查用户的同步状态时,它是显示此错误
远程服务器'服务器名称'不存在,或者尚未被指定为有效的发布者,或者您可能没有权限
在发布商表中,添加了唯一标识符列,但未在订阅者表中添加。
任何人都可以知道这个..?
Hi,
I am trying to replicate the data with "Transaction replication with subscriptions".
I have done all the process according to this link
https://www.youtube.com/watch?v=rPs8FV5lHEM
But data is not getting replicated into another instance of SQL Server.
When i check the synchronization status of subscriber it is showing this error
"The remote server 'server name' does not exist, or has not been designated as a valid Publisher, or you may not have permission"
In publisher table, Unique identifier column was added, but it doesn't added in subscriber table.
can any one know about this..?
推荐答案
我无法在这里访问youtube。
检查这些
SQL 2012 - 远程服务器不存在,或者尚未被指定为有效的发布者,或者您可能无权查看可用的发布者 [ ^ ]
创建时出错订阅 [ ^ ]
更多...... [ ^ ]
I can't access youtube here.
Check these
SQL 2012 - The remote server does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers[^]
Error when creating a subscription[^]
And more...[^]
这篇关于具有订阅的事务发布不起作用。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!