The interesting things I experimented with SQl Server.
This is a proper netwrok error and has nothing to do with the coding if any of your jobs/queries/packages fail with this message.
Please refer the following article for the workaround.
http://support.microsoft.com/kb/942861/en-us
Another work around we tried and succeeded in our project was as follows:
There is something called Network Speed setting which is usually set to AUTO or a fixed value. You can check this from Start->Control Panel->Network Connections->Local Area Connection->Properties->Configure->Advanced->Speed &Duplex property. Change it to 100 MBPS full or whatever value that matches the configuration of the n/w port on the switch side. It solved the issue for us.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using