/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

48 votes288 views3 answers
Psql create database
SQL
-1 vote199 views1 answer
Mysql select count if contains
SQL
24 votes218 views6 answers
Replace mysql
SQL
0 vote195 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote272 views1 answer
Python mysql check if database exists
SQL
1 vote183 views1 answer
Primary key with prefix sql
SQL
1 vote252 views1 answer
Backup mysql schema only
SQL
1 vote190 views1 answer
Declare variables sql
SQL
1 vote152 views1 answer
Convert money to varchar sql server
SQL
0 vote186 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL