SQL Communication Link Error's

Legacy Contributor

Getting ton's of SQL communication link errors since I have upgraded from Terminal Server 2003R2 to Virtual Terminal Server(RDS) 2008R2SP1.

Applied all network fixes suggested by Inforxtreme, Applied a MS hotfix KB2775511 and still getting the errors.

Anyone else experienced this??

Thanks,
Gerald

Legacy Contributor

We had this same problem when we upgraded to Visual 7 on SQLServer 2008R2. Turns out that the drivers on the NIC cards on our workstations needed to be updated. Windows said we had the latest and greatest, but when I went to the manufacturer's website (for the NIC cards), there were updates available. I know there are a lot of hardware issues that could cause this problem (bad switch, bad port on the switch, bad wiring, etc), but this is an easy fix to try. FWIW, we are not running Virtual Terminal Server. When you find the answer, could you please post? Good luck!