Hi, I am trying to create connection to my mssql server using typeorm in node 20 application. I am getting socket hang-up error, the connection gets created if I set encrypt to false. I tried all tls configuration and everything but I am not able to solve this error. Node version: 20.15.0 mssql: 10.11.0 Please help.

Hi @Kasthuri C M , Thank you for your reaching out and welcome to Microsoft Q&A! You mentioned that: I am getting socket hang-up error, the connection gets created if I set encrypt to false. Encrypt=false indicates the client does not require encryption, this is the cause of creating successfully. TLS will still use when possible, encrypting login credentials at a minimum. Below is the relevant excerpt from the encryption support . I am getting socket hang-up error Could you please post the detailed error messages here to help us narrow down the issue? Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further. Best regards, Lucy Chen 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". Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread. <a href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fanswers%2Fsupport%2Femail-notifications&data=05%7C02%7Cv-xinc%40microsoft.com%7C9b8c827cb42642ce852408dc43e66a2a%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638459904116612195%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=Enb7k6yaPROUCn4EQgXIrCLX2qXwUpzmasNuBLy%2BznA%3D&reserved=0" rel="ugc nofollow">https://docs.microsoft.com/en-us/answers/support/email-notifications

I am making a connection to mssql using typeorm and getting error

Accepted answer

LucyChenMSFT-4874 4,750 Reputation points

2024-07-12T02:02:57.3366667+00:00

Hi @Kasthuri C M ,

Thank you for your reaching out and welcome to Microsoft Q&A!

You mentioned that:

I am getting socket hang-up error, the connection gets created if I set encrypt to false.

Encrypt=false indicates the client does not require encryption, this is the cause of creating successfully. TLS will still use when possible, encrypting login credentials at a minimum. Below is the relevant excerpt from the encryption support.

I am getting socket hang-up error

Could you please post the detailed error messages here to help us narrow down the issue?

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

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".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications
Please sign in to rate this answer.
LucyChenMSFT-4874 4,750 Reputation points

2024-07-19T05:30:48.8+00:00

Hi @Kasthuri C M ,

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen

LucyChenMSFT-4874 4,750 Reputation points

2024-07-23T02:22:30.86+00:00

Hi @Kasthuri C M ,

I hope the answers below is helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.

Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for your understanding! :)

Best regards,

Lucy Chen

Kasthuri C M 20 Reputation points

2024-07-26T05:19:42.3633333+00:00

The connection to mssql server via MSSQL Server management studio with encrypt = true works well with no connection error, but when I tried to do the same via my NestJS application using TypeORM library I get this connection error.
I am not sure what I am missing.
Please find the detailed error below:

"message":"{\"stack\":\"ConnectionError: Failed to connect to {DB_URL} - socket hang up\\n at C:\\\\node_modules\\\\mssql\\\\lib\\\\tedious\\\\connection-pool.js:85:17\\n at err (C:\\\\node_modules\\\\tedious\\\\src\\\\connection.ts:1759:9)\\n at Object.onceWrapper (node:events:633:26)\\n at Connection.emit (node:events:518:28)\\n at Connection.emit (node:domain:488:12)\\n at emit (C:\\\\node_modules\\\\tedious\\\\src\\\\connection.ts:1902:18)\\n at socketError (C:\\\\node_modules\\\\tedious\\\\src\\\\connection.ts:2309:12)\\n at socketEnd (C:\\\\node_modules\\\\tedious\\\\src\\\\connection.ts:2326:12)\\n at Socket. (C:\\\\node_modules\\\\tedious\\\\src\\\\connection.ts:1997:35)\\n at Socket.emit (node:events:530:35)\"

LucyChenMSFT-4874 4,750 Reputation points

2024-07-26T06:29:16.17+00:00

Hi @Kasthuri C M ,

Glad to hear that you were able to resolve the issue!

About the new issue you encountered, please refer to this article, it shows the steps in How to Use SQL Databases in a NestJS Application With TypeORM in detail!

You can try again by following the steps in this article!

In addition, here is a known issue like yours, hope it can help you well!

Feel free to share your issues here if you have any concerns! We will offer you more support!

Best regards,

Lucy Chen
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

I am making a connection to mssql using typeorm and getting error

0 additional answers

Your answer