Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package

Omar_Osman — Thu, 07 Mar 2024 16:37:57 GMT

Software versions

tedious: "^17.0.0"
Node.js:18.17.1

Problem description
Got an error message when connecting to Microsoft Fabric SQL Endpoint

ConnectionError: Connection lost - socket hang up {at Connection.socketError ... node_modules\tedious\lib\connection.js:1344:26) code: 'ESOCKET' }

Note:that the connection works when using the powershell with the same parameters.

Install-Module -Name SqlServer $connectionString = "Server=$server;Database=$database;User Id=$username;Password=$password;Authentication=Active Directory Password;Encrypt=True;TrustServerCertificate=False;" # Create a SQL connection $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnection.ConnectionString = $connectionString

Best Regards,

Re: Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package

lbendlin — Thu, 07 Mar 2024 23:24:41 GMT

that "socket hang up" seems to be a rather popular error message lately.

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

topic Re: Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package in Developer

Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package

Re: Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package