Node-mssql: After update: ConnectionError: Failed to connect to SERVERNAME:1433 - Cannot call write after a stream was destroyed

Created on 19 Feb 2020  路  1Comment  路  Source: tediousjs/node-mssql

After update to 6.1.0 node-mssql failed to connect to database. When roolback to 6.0.1 it works.

Expected behaviour:

Connect to database

Actual behaviour:

ConnectionError: Failed to connect to SERVERNAME:1433 - Cannot call write after a stream was destroyed

Configuration:

{
    user: 'username',
    password: 'mypassword',
    server: 'servername',
    database: 'dbname',
    options: {
        appName: 'app',
        useUTC: false,
        enableArithAbort: false
    }
}

Software versions

  • NodeJS: v12.9.1
  • node-mssql: [email protected]
  • tedious: ^6.6.2 (dependency)
  • SQL Server: 12.0.2269.0

Version working

Most helpful comment

You'll need to set encrypt: false as the default value is true (https://github.com/tediousjs/node-mssql#tedious)

>All comments

You'll need to set encrypt: false as the default value is true (https://github.com/tediousjs/node-mssql#tedious)

Was this page helpful?
0 / 5 - 0 ratings

Related issues

andrewmcgivery picture andrewmcgivery  路  5Comments

srglovin picture srglovin  路  4Comments

cdeutsch picture cdeutsch  路  6Comments

sizovilya picture sizovilya  路  3Comments

aerze picture aerze  路  3Comments