question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked Cathyji-msft answered

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

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

sql-server-generalazure-network-watcher
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @MSTechie-7364,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.