A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.)
SQL – last time this error occurred in my Azure Environment when I am using SoftEther VPN installed on the SQL server. When I moved it to the Linux Server it disappears.
So this is confirmation that it is strictly connected with network connectivity, but I was not indicated what exactly the problem was. So fast and working solution.