Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate

Question

Get this error while connecting my node js to MSSQL server.

PS C:\Users\ANJALI\Documents\Curate\Website\Backend> node index.js

ConnectionError: Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate

at Connection.socketError (C:\Users\ANJALI\Documents\Curate\Website\Backend\node_modules\tedious\lib\connection.js:1338:28)

at C:\Users\ANJALI\Documents\Curate\Website\Backend\node_modules\tedious\lib\connection.js:2238:25

at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {

code: 'ESOCKET'

}

Answer 1

Hi @Anjali Kumawat

How about adding trustedConnection: true, inside the options of connectionSettings?

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".