Network Watcher - ConnectionMonitor from Azure VM to another VM having SQL Server

MS Techie 2,701 Reputation points
2021-08-24T15:34:53.917+00:00

Hi,
I have setup an Azure Network watcher - Connection Monitor to test connectivity from Azure VM to another Azure VM having SQL Server on port 1433. (Source is Azure VM and Destination is SQL Azure Virtual machine)

On the Target SQL Server, in the event viewer , i get the below message, whenever the connection monitor checks the connectivity from Azure VM to another having SQL Server ,
Error is as below
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library.

What can i do to resolve this error

Azure Network Watcher
Azure Network Watcher
An Azure service that is used to monitor, diagnose, and gain insights into network performance and health.
169 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,786 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2021-08-25T03:30:28.68+00:00

    Hi @MS Techie ,

    I am not familiar with Azure network watcher.

    > Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library.

    Here are few more causes based on my search on the internet:

    1.Network team doing Port Scanning
    2.Sometimes Antivirus programs do check the port.
    3.MSSQL server is under a DDoS

    Refer to the blog FIX: Error 17836: Length Specified in Network Packet Payload Did Not Match Number of Bytes Read; the Connection has been Closed.

    This is an old thread that has same error message in SQL, please check the solution from this thread. Hope it could help you.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 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.