/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 vote179 views1 answer
Test sql query
SQL
2 votes182 views2 answers
Run mysql command from bash
SQL
1 vote186 views1 answer
Psql import backup file for windows
SQL
0 vote185 views1 answer
Allow null in psql
SQL
0 vote179 views1 answer
Postgres create extension if not exists
SQL
0 vote164 views1 answer
Export partttion and import in oracle
SQL
0 vote174 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
3 votes210 views2 answers
@sqlresultsetmapping
SQL
0 vote202 views1 answer
Sql int vs integer
SQL
1 vote227 views4 answers
How to check table in postgresql from terminal
SQL