TCP提供程序：远程主机强制关闭现有连接 [英] TCP Provider: An existing connection was forcibly closed by the remote host
问题描述
嗨
从SQL代理作业（托管在SQL Server 2014上）运行SSIS包时出现以下错误。该软件包只是从SQL Server 2016 Std版本的master数据库中收集DB名称，并在同一SQL服务器2016上插入master中的表。
I am getting the below error when running a SSIS package from SQL agent job(hosted on SQL server 2014). The package is just to collect DB name from master database on SQL server 2016 Std edition and insert into a table in master on the same SQL server 2016.
我检查了几个区域（例如TCP / IP启用，防火墙，端口1433等..）但仍然遇到问题。我还修补了SP2到SQL Server 2016以查看它是否有帮助，但它不是。
I have check several areas (such as TCP/IP enabled, firewall, port 1433 and so on..) but still getting issues. I have also patched SP2 to SQL server 2016 to see whether it helps but it's not.
当我在本地计算机上运行但不在SQL Server 2014上的SQL代理作业时，该程序包可以正常运行。我在SSIS pacakge中使用DelayValidation设置为True，EncryptSensitiveWithPassword / UserKey。我甚至尝试使用MSDTC配置，但仍然没有
运气。
The package works when I run on my local machine but not from SQL agent job on SQL server 2014. I have played with DelayValidation setting to True, EncryptSensitiveWithPassword/ UserKey in SSIS pacakge. I even tried with MSDTC configuration but still no luck.
任何帮助都将不胜感激。
Any help would be appreciated.
恢复数据库备份：错误：SSIS错误代码DTS_E_OLEDBERROR。 发生OLE DB错误。错误代码：0x80004005。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："客户端无法建立连接"。
OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0" Hresult：0x80004005 说明："TCP提供程序：远程主机强行关闭现有连接。
Restore DB Backup:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Client unable to establish connection".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
推荐答案
嗨Kay Lwin，
Hi Kay Lwin,
这里有几篇关于这个主题的好帖子：
Here is a couple of good posts on the subject:
这篇关于TCP提供程序：远程主机强制关闭现有连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
