I am seeing below connectivity error while executing queries on a database. how can we fix this.
Transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
If we connect to a jump server and make a connection to server and execute the query, the query runs successfully.
However, when we try to connect to the server from a local desktop or a laptop and run the same query, it runs for sometime and we get above error.
SQL Server Version
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)
Aug 15 2017 10:23:29
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)