Sqlserver遇到TCP Provider An existing connection was forcibly closed by the remote host的解决方法

报错TCP Provider: An existing connection was forcibly closed by the remote host
如下图，在dwprod2(服务器名dbprod96)服务器执行远程调用dbprod4\datamart服务器的job报错TCP Provider: An existing connection was forcibly closed by the remote host

这类错误在官方文档里面有记录https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-exist-connection-closed，大概分为几种情况一一排查下去即可，本人的场景是因为目标端dbprod4的HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL下面多了除SSL2.0以外的TLS和PCT等协议，把dbprod4注册表HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL下面的注册信息export一份当成备份，再删除其他协议，只保留SSL2.0
备注：有时候也需要查看dbprod\datamart这个Sqlserver实例SQL Server Configuration Manager --SQL Server Network Configuration-- Protocols for DATAMART–TCP/IP–IP Addresses中的ip 是否配置成了其他服务器的IP