/SQL/Failed to connect to localhost:1433 - self signed certificate

Failed to connect to localhost:1433 - self signed certificate

const config = {
  port: parseInt(process.env.DB_PORT, 10),
  server: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
  database: process.env.DB_Database,
  stream: false,
  options: {
    trustedConnection: true,
    encrypt: true,
    enableArithAbort: true,
    trustServerCertificate: false,

  },
}

sql.connect(config).then(pool => {
  if (pool.connecting) {
    console.log('Connecting to the database...')
  }
  if (pool.connected) {
    console.log('Connected to SQL Server')
  }
})

Source: stackoverflow.com

Similar codes

0 vote139 views1 answer
How to execute stored output to csv files
SQL
8 votes150 views1 answer
Oracle add months to sysdate
SQL
0 vote156 views1 answer
Hibernate dialect property xml for mysql 8
SQL
-1 vote158 views1 answer
How to reset autoincrement in sqlite java
SQL
2 votes156 views3 answers
Sql truncate table
SQL
2 votes163 views1 answer
Oracle percentage
SQL
0 vote163 views1 answer
Plsql check for string in numeric
SQL
0 vote176 views1 answer
Alter owner in PostgreSQL
SQL
0 vote191 views1 answer
Plpgsql create function
SQL
8 votes152 views6 answers
Sql insert
SQL