/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

2 votes200 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote194 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote189 views1 answer
T sql less than date
SQL
0 vote157 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
3 votes186 views1 answer
Force using index oracle
SQL
6 votes201 views3 answers
Mysql create database utf8
SQL
3 votes184 views4 answers
Mysql create table from select statement
SQL
1 vote203 views1 answer
Declare table variable
SQL
6 votes181 views2 answers
Insert into select mysql
SQL
10 votes184 views1 answer
Oracle all_dependencies
SQL