/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

6 votes204 views1 answer
To count number of rows in SQL table
SQL
6 votes229 views2 answers
WHERE value IS sql
SQL
2 votes174 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote189 views1 answer
Intellij idea add mysql connector
SQL
-1 vote180 views1 answer
Round up and down sql
SQL
2 votes181 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote192 views1 answer
Postgres reorder columns
SQL
0 vote211 views1 answer
Database db connection string format
SQL
0 vote191 views1 answer
Add super privilege mysql
SQL
0 vote162 views2 answers
Delete query sql server
SQL