/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

2 votes268 views1 answer
Compare date in sql
SQL
0 vote287 views2 answers
Select a row include list of array with join two table SQL
SQL
1 vote266 views1 answer
How to between in sql
SQL
0 vote333 views1 answer
How to rename a database in tsql
SQL
3 votes266 views1 answer
Kill mysql processlist in whose time more than 200
SQL
-1 vote222 views1 answer
How to create script to connect to oracle database and run query
SQL
11 votes292 views2 answers
Having clause in sql
SQL
0 vote255 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote265 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote265 views1 answer
Reset postgresql password windows
SQL