This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
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'
}
Are you sure that you have trustServerCertificate in the right place? I can't see why it would be under authentication. Rather, I would expect it to be in the same place as the encrypt option.
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".
@LiHongMSFT-4306 I tried removing this also but not working.