A timeout error means that a certain operation takes longer than needed. The client application stops the operation (instead of waiting indefinitely), which may block other operations and suspend an application.
sql timeout error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 74%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
k muthus
41
Reputation points
We have a query that queries huge table . after some time we get that error
A transport-level error has occurred when receiving results from the server.
tried increasing the timeout also . no improvement
is there any way to fix
SQL Server | Other
-
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator2022-03-10T22:32:33.46+00:00 As Olaf said, this sounds like a network issue.
Does the error occur when data is being return to the client, or while it is still "working on it"? How many rows do you expect to be returned?
Sign in to comment
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Michael Johnson 6 Reputation points2022-09-08T05:43:44.767+00:00 -
Olaf Helper 47,616 Reputation points2022-09-08T06:32:06.94+00:00 A timeout error means that a certain operation takes longer than needed.
Read the error message, it's not a command timeout, it's a network related error.
Sign in to comment -
-
Olaf Helper 47,616 Reputation points
2022-03-10T06:41:24.733+00:00 A transport-level error has occurred when receiving results from the server.
That error has nothing to do with any time out, it's more a network related issue. Check it with your IT dept.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YufeiShao-msft 7,156 Reputation points2022-03-10T06:05:01.09+00:00 Hi @k muthus ，
What are the specific error received? What the error log says? Because there are many reason for this error.
Since you mentioned the timeout
It mainly occurs due to an issue with the connection/network. Verify network latency in your network
Incorrect TCP/IP settings, inappropriate network packet size configured in SQL Server, Network Interface Card driver issueEnsure the firewall allow SQL Server access
If you use a VPN to get connected? Maybe the issue happens when you are connected or disconnected from the VPN.https://stackoverflow.com/questions/853676/how-to-avoid-sql-query-timeout
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.