/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 vote121 views1 answer
Alter table engine mysql
SQL
9 votes117 views2 answers
Get first 3 letters in sql
SQL
1 vote111 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote114 views4 answers
Psql check tables command
SQL
0 vote106 views1 answer
Sql select inside select sub query
SQL
0 vote103 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote120 views1 answer
Oracle sql first day of year
SQL
18 votes105 views2 answers
Sql comments
SQL
0 vote115 views1 answer
Mysql count unique in group statement
SQL
0 vote114 views2 answers
Mysql two column combination unique
SQL