SQL Server is reporting "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"

denisenkom / go-mssqldb

Microsoft SQL server driver written in go language

BSD 3-Clause "New" or "Revised" License

1.82k stars 495 forks source link

SQL Server is reporting "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" #699

Open rthugh02 opened 2 years ago

rthugh02 commented 2 years ago

Describe the bug After establishing a connection with sql.Open(), any attempts to interact with the DB connection causes an error to be reported (Ping(), QueryRow(), etc.): "read tcp [client]->[server]:1433: read: connection reset by peer"

Reviewing the SQL Server error logs on the remote server, the message in the title is found.

The remote server is running SQL Server 2005