# Mssql-plus - ECONNCLOSED - Connection is closed

**URL:** <https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083>\
**Category:** General\
**Created:** [23 August 2021 20:09 UTC](https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083 "2021-08-23T20:09:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tusharacc](https://avatars.discourse-cdn.com/v4/letter/t/74df32/32.png) [@tusharacc](https://discourse.nodered.org/u/tusharacc)\
**Post date:** [23 August 2021 20:09 UTC](https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083/1 "2021-08-23T20:09:28Z")

</div>

I have a below flow -

```auto
Inject -> Query SQL Server A -> Randomly Select 10 records -> split (based on array length of 1) -> Query SQL Server B -> debug message object

```

During this flow, I get connection is closed for the "Query SQL Server B" node for all the individual payload but last. No error message is thrown if flow is updated to select only 1 random record. If I make it 2, I start getting the error. Any pointers?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [23 August 2021 21:21 UTC](https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083/2 "2021-08-23T21:21:12Z")

</div>

> [@tusharacc](#):
>
> Any pointers?

Yes, you are probably exhausting the pool or hitting a connection limit.

Where is the SQL server? in the cloud / azure? On premise? What version?

To counter this, try the following...

1. increase pool to 10
2. put a delay node after `split` node set to "rate limit" mode  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/c/1c0dac9abb9f4b52157ecfb0b71ee6b9682f2ee8.png)

---

<div class="post-metadata">

**Author:** ![tusharacc](https://avatars.discourse-cdn.com/v4/letter/t/74df32/32.png) [@tusharacc](https://discourse.nodered.org/u/tusharacc)\
**Post date:** [24 August 2021 19:29 UTC](https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083/3 "2021-08-24T19:29:51Z")

</div>

Thanks for the response, I was able to resolve the issue.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [7 September 2021 19:30 UTC](https://discourse.nodered.org/t/mssql-plus-econnclosed-connection-is-closed/50083/4 "2021-09-07T19:30:23Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.