/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 vote205 views1 answer
Create table with float datatype in sql server
SQL
0 vote237 views1 answer
Mysql concatenate select results
SQL
0 vote200 views1 answer
Limit in access query
SQL
0 vote200 views1 answer
Tsql cmd exec script from file
SQL
-3 votes186 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote207 views1 answer
Excel export from sql using python
SQL
0 vote183 views1 answer
SQL server select to get sum of hours
SQL
0 vote247 views5 answers
Select concat alter table mysql
SQL
0 vote230 views1 answer
Oracle to_number
SQL
0 vote199 views1 answer
Find most frequent value in SQL column
SQL