The specified network name is no longer available Unspecified error
我有一台Server与另一台建了LinkServer 然后Server1上运行的存储去Server2上的table抓数据塞到Server1的table里,最近总是在执行Server1的job run这个存储时候报错
TCP Provider: The specified network name is no longer available. [SQLSTATE 42000] (Error 64) OLE DB provider "SQLNCLI11" for linked server "172.21.xx.xx" returned message "Unspecified error". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI11" for linked server "172.261.xx.xx" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI11" for linked server "172.21.xx.xx" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.
其中172.21.xx.xx是Server2
这是什么情况?我看了下LinkServer没动过,之前怎么设置现在还是什么样,然后看了Server2的connectiong,也没有几个,并发执行数量不多,网络也没有什么报错的日志,也没什么异常,这个报错是怎么回事?