/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

9 votes214 views2 answers
Sql limit to 5 results
SQL
0 vote204 views1 answer
Sql row number in result set
SQL
2 votes178 views1 answer
Foreign key example in dbms
SQL
0 vote216 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote215 views1 answer
Sql select lowest value row
SQL
0 vote219 views1 answer
Convert rows to columns in sql server
SQL
16 votes220 views5 answers
Select last row in sql
SQL
0 vote203 views1 answer
Oracle last character of string
SQL
1 vote214 views1 answer
What is intersect
SQL
0 vote170 views1 answer
Count char in java
SQL