SQL server connectivity issue

Occasional Reader

I am trying to connect to sqlserver using sqlcmd command line tool, but its failing.
Error logs on server side:
Date Source Message 10/29/2024 3:43:08 PM Logon 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. [CLIENT: 48.216.198.190] 10/29/2024 3:43:08 PM Logon Error: 17836, Severity: 20, State: 17.

From client side
sqlcmd -S 3.14.36.201 -U svc_lightbeam_temp -P <> -d master
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.

sqlserver details
Microsoft SQL Server 2016 (SP1-CU8) (KB4077064) - 13.0.4474.0 (X64)  Feb 24 2018 13:53:17  Copyright (c) Microsoft Corporation Web Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)



0 Replies