'I have problem involved in Connection between nodejs and mssql

I tried running this code but it shows the following error

'ConnectionError: Failed to connect to LAPTOP-VNS3VHIC:1433 - self signed certificate
    at C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\tedious\connection-pool.js:70:17
    at Connection.onConnect (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1038:9)
    at Object.onceWrapper (events.js:482:26)
    at Connection.emit (events.js:375:28)
    at Connection.emit (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1066:18)
    at Connection.socketError (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1412:12)
    at Socket.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1177:14)
    at Socket.emit (events.js:387:35)
    at emitErrorNT (internal/streams/destroy.js:106:8)
    at emitErrorCloseNT (internal/streams/destroy.js:74:3) {
  code: 'ESOCKET',
  originalError: ConnectionError: Failed to connect to LAPTOP-VNS3VHIC:1433 - self signed certificate
      at Connection.socketError (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1412:28)
      at Socket.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1177:14)
      at Socket.emit (events.js:387:35)
      at emitErrorNT (internal/streams/destroy.js:106:8)
      at emitErrorCloseNT (internal/streams/destroy.js:74:3)
      at processTicksAndRejections (internal/process/task_queues.js:82:21) {     
    code: 'ESOCKET',
    isTransient: undefined
  }
}
RequestError: No connection is specified for that request.
    at Request._query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\base\request.js:493:37)
    at Request._query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\tedious\request.js:363:11)
    at Request.query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\base\request.js:429:12)
    at C:\Users\dtvin\OneDrive\Máy tính\mssql\index.js:14:16
    at Immediate.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\global-connection.js:56:7)
    at processImmediate (internal/timers.js:466:21) {
  code: 'ENOCONN'
}
undefined'
const sql = require('mssql')
const config = {
    user: 'sa',
    password: '123456789',
    server:'LAPTOP-VNS3VHIC',
    database: 'TestDb',
    port: 1433
};
sql.connect(config , function (err) {
    if(err) console.log(err);
    let sqlRequest = new sql.Request();

    let sqlQuery = 'Select * from Persons'
    sqlRequest.query(sqlQuery , function(err , data) {
        if(err) console.log(err);

        console.table(data)

        sql.close();
    })
})


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source