how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

sharuk 0 Reputation points
2024-04-24T08:07:29.2066667+00:00

When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on date column called created on . so when ever I am running or executing this both quires simultaneously I am getting error message like this Msg 64, Level 20, State 0, Line 114

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) at window where The query is executing to fetch the data by joining various tables .

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,016 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 26,491 Reputation points
    2024-04-24T13:17:47.2733333+00:00

    I think the issue is network-related between your client and the SQL Server.

    If you are running these queries from a remote location, consider testing the connection and operations from a different network or closer to the data center where the Azure SQL Database is Keep in mind that running a deletion query with rollback capabilities and a complex join operation simultaneously can be very resource-intensive. This might lead to timeouts or network disruptions if the server is overburdened.

    If these steps don't resolve the issue, it might be worthwhile to contact Azure support for a more in-depth investigation, especially to explore network-related issues beyond your control.

    More links :

    https://stackoverflow.com/questions/2962927/a-transport-level-error-has-occurred-when-receiving-results-from-the-server

    https://learn.microsoft.com/en-us/answers/questions/1340346/a-transport-level-error-has-occurred-when-receivin

    https://support.teromarine.com/article/30-transport-level-error-the-specified-network-name-is-no-longer-available

    0 comments No comments

  2. MikeyQiaoMSFT-0444 3,190 Reputation points
    2024-04-25T03:33:14.5733333+00:00

    Hi,sharuk

    Welcome to Microsoft Q&A forum !

    This is a question about the connection between the client and the SQL instance. I'm not sure if this issue is sporadic or has always existed and never been resolved. The cause may be related to firewall settings, excessive resource consumption leading to query timeouts, or network routing settings (such as a misconfigured option in a site-to-site VPN).

    You can refer to:

    https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql

    https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?view=dotnet-plat-ext-8.0&redirectedfrom=MSDN#System_Data_SqlClient_SqlCommand_CommandTimeout

    https://learn.microsoft.com/en-us/answers/questions/336122/azure-data-factory-azure-sql-connectivity-error-a

    Best regards,

    Mikey Qiao


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.