SQLServer 事务复制分发错误 The process could not connect to Subscriber
来源:互联网 发布:html5数据统计模板 编辑:程序博客网 时间:2024/06/07 05:02
非域环境创建事务复制,使用IP相互连接正常。都用IP创建数据库别名,这时使用服务器名相互连接也正常。
但是初始化复制时,失败了!其他服务器按别名配置的,都能正常复制。但是这两台服务器同样配置,却不成功!
分发进程无法连接到订阅服务器!错误如下:
Error messages:The process could not connect to Subscriber 'DB-Subscriber'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)Get help: http://help/MSSQL_REPL0TCP Provider: 不知道这样的主机。 (Source: MSSQLServer, Error number: 11001)Get help: http://help/11001A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (Source: MSSQLServer, Error number: 11001)Get help: http://help/11001Login timeout expired (Source: MSSQLServer, Error number: HYT00)Get help: http://help/HYT00
最后解决方法:hosts 文件中将IP和服务器名绑定。
C:\Windows\System32\drivers\etc\hosts
有点奇怪,有很多单向复制的服务器,都正常,唯独这台,需要在发布服务器的hosts绑定订阅服务器名称和IP。
注:此服务器是阿里云服务器,该服务器即是订阅服务器,也是另一组复制的发布和分发服务器。作为分发服务器需要绑定IP!
0 0
- SQLServer 事务复制分发错误 The process could not connect to Subscriber
- 同步复制错误:The process could not execute 'sp_replcmds' on 'servername'
- 【xcode】错误之Could not launch "" failed to get the task for process
- 41.【xcode】错误之Could not launch "" failed to get the task for process
- TSM错误:ANR1820E The server could not connect to the database manager by using TCP/IP port 51500.
- Oozie配置mysql 时 Could not connect to the database:
- DVWA问题 2:Could not connect to the MySQL service.
- svn错误问题处理could not connect to server
- svn错误问题处理could not connect to server
- svn错误问题处理could not connect to server
- MonoDevelop提示Could not connect the debugger错误
- Could not connect to the view server 运行问题补充的脚本 提出上面的错误,怎么解决呢
- Could not launch “***”process launch failed: failed to get the task for process 402
- the vsphere client could not connect to you do not have permission to login to the server
- SqlServer 复制中将大事务分成小事务分发
- Failed to connect to the specified server. Server library could not be loaded
- Unable to start T-SQL Debugging. Could not connect to the computer ‘.’
- mplayer: could not connect to socket mplayer
- 如何让IIS 能响应HTTP PUT和DELETE请求
- struts2 Action获取request,session,application
- 数据结构——12 删除两个双向链表中相同的节点
- localhost、Tomcat的localhost:8080拒绝访问解决方案(win10系统)
- c#:通过MD5得到文件和String的校验值
- SQLServer 事务复制分发错误 The process could not connect to Subscriber
- HDU 4452 Running Rabbits
- videoPlayer
- 数据库中INFORMATION_SCHEMA的说明及使用
- 在覆盖toString()方法中使用this所发现的有趣的现象
- 笔记:Jsp页面国际化 – 使用jstl标签
- oralce定时任务 最详细
- SpringMVC + Mybatis +JSON + mysql 进行批量插入的实例操作
- dpkg命令的用法