SQL Server事务复制 [英] SQL Server Transactional Replication

问题描述

大家好，

我在sql server事务复制中遇到了一些问题.我收到以下消息"The process could not connect to the subscriber servername\instance name " 操作系统和sql服务器的详细信息.

1.我在两台服务器上都使用sql server 2005标准版.
2.操作系统是Windows 2003 Server
3.SQL Server列出端口号1433，并且该端口在防火墙中是双向打开的
4. Sebscriber服务器是远程服务器，我可以从两侧的主服务器(分发服务器)连接实例
5.我能够执行DTS.
6.我已经尝试过推送订阅
7.配置期间没有错误消息.
8.主服务器在工作组中，而第二服务器在域中.
9.我可以通过IP地址和名称访问这两个服务器.


谁能协助我在哪里做错了.我认为存在一些与Windows相关的身份验证问题，我无法跟踪任何帮助，因此会造成麻烦.


问候，
Sunil Tiwari

Hello All,

I am facing some problem in sql server transactional replication. I am getting the message "The process could not connect to the subscriber servername\instance name " The operating systen and sql server details below.

1.I am using sql server 2005 standard edition on both servers.
2.The operating system is windows 2003 server
3.SQL server listning port number 1433 and the port is bidirectional opened in firewall
4. Sebscriber server is remote server and I am able to connect the instance from primary (distributor) server on both side
5. I am able to do the DTS.
6. I have tried pull and push subscription
7. There is no error messages during configuration.
8. Primary server is on workgroup and secondry server is having domain.
9. I can access the both servers by ip address and name.


Can anyone assist me where I am doing wrong. I thinks there is some windows related authentication issue which I am not able to trace any help would be higly appriciated.


Regards,
Sunil Tiwari

推荐答案

修复链接

SQL Server故障排除-分发代理:进程无法连接到订户"XXXX" [ ^ ]
如何:在非受信任域中或整个Internet上运行SQL Server的计算机之间进行复制 [

Fix links

SQL Server Troubleshooting - Distribution Agent: The process could not connect to Subscriber ''XXXX''[^]
HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet[^]

这篇关于SQL Server事务复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！