Communication Link Error on ArcMap 10.4.1

Question

I have setup a geodatabase on SQL Server 2014 and then installed ArcMap 10.4.1 on a client PC. The ArcMap can open the feature classes and tables on SQL Server, but once the PC screen is locked, after unlock, the ArcMap prompts communication link error but the connection between PC and SQL Server is normal. Anyone have ideas?

MatsHardy · Answer

Thanks for your help. I have just figured out what happened.

On Win 10, TCP chimney is disabled by default. SQL Server connection often loses after the PC is idle for certain period of time and TCP chimney is disabled. The problem is resolved after TCP chimney is enabled on client PC.

George Thompson · Answer

If you can narrow down the time that is "needed" for the issue to occur, you can go talk to your network team and see if they have any sort of "time limit" that a network port can stay open.

This is something that I have seen in the past, it will occur after a set amount of time (i.e. 30 minutes).

MatsHardy · Answer

Thanks for your help.

I have installed only the SQL Server 2012 Native Client.

Yes, the error happen after I left the PC locked for a certain period of time.