/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 votes119 views1 answer
Sql alchemy or
SQL
4 votes161 views6 answers
Select sql
SQL
2 votes126 views1 answer
Find all triggers in database
SQL
0 vote140 views1 answer
Sql decimal to 2 places
SQL
1 vote122 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote127 views1 answer
Top 3 salary in sql
SQL
2 votes131 views2 answers
Sqlite_busy: database is locked
SQL
1 vote125 views1 answer
Mysql get max value and id
SQL
2 votes118 views1 answer
Oracle number to percentage
SQL
0 vote165 views1 answer
Print hello world in plsql
SQL