We have a two node active-active Windows 2008 R2 cluster with two instances of SQL 2008 R2 installed on it. ServerA and ServerB are the physical nodes, ServerF and ServerG\Inst2 are the default and named instances respectively. From last few days we have been receiving following error quite frequently in our SQL error logs.Please advise.
Error: 4014, Severity: 20, State: 2." A fatal error occurred while reading the input stream from the network.
Just googled after the error and found this connect item
It talks about 4014 errors and says to check if the errors are occurring with the same client or not. If yes, then check for NIC issues on the client, if no, then check the server.
Following query should give information on connectivity issues of this kind :