# How can I change mssql connection timeout value?

**URL:** <https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573>\
**Category:** General\
**Tags:** database\
**Created:** [1 December 2021 13:43 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573 "2021-12-01T13:43:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vi-rgaigl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/vi-rgaigl/32/51869_2.png) [@vi-rgaigl](https://discourse.nodered.org/u/vi-rgaigl)\
**Post date:** [1 December 2021 13:43 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/1 "2021-12-01T13:43:50Z")

</div>

I have a database query that takes about 90 seconds (database very large and complex query with many joints).  
I always run into a connection timeout of 15000 ms with the mssql node. How can I change the value?

I use node-red-contrib-mssql-plus : MSSQL v0.7.3.

I already tried to export the node and import the changed JSON again. It did not work.

---

<div class="post-metadata">

**Author:** ![ScheepersJohan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scheepersjohan/32/39556_2.png) [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Post date:** [1 December 2021 13:56 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/2 "2021-12-01T13:56:43Z")

</div>

> [@vi-rgaigl](#):
>
> node-red-contrib-mssql-plus

Welcome @vi-rgaigl to the forum

Are there a specific reason you use this node?

---

<div class="post-metadata">

**Author:** ![vi-rgaigl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/vi-rgaigl/32/51869_2.png) [@vi-rgaigl](https://discourse.nodered.org/u/vi-rgaigl)\
**Post date:** [1 December 2021 14:37 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/3 "2021-12-01T14:37:47Z")

</div>

thank you for the quick reply  
No.  
With the node-red-contrib-mssql v0.0.7 node it didn't work either, so I thought it might be possible with the node.  
Or is there basically another way to do MS database queries?

---

<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:** [1 December 2021 14:45 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/4 "2021-12-01T14:45:29Z")

</div>

> [@ScheepersJohan](#):
>
> Are there a specific reason you use this node

Its the most up-to-date, has most features and is most supported (by me).

@vi-rgaigl the correct fix is to have the DBA to restructure data and/or add indexes to speed up the query. Otherwise, you can change the timeout in the config node

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/5/95baeb962c0944ade0f97b92c4694b448598ca5f.png)

---

<div class="post-metadata">

**Author:** ![vi-rgaigl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/vi-rgaigl/32/51869_2.png) [@vi-rgaigl](https://discourse.nodered.org/u/vi-rgaigl)\
**Post date:** [2 December 2021 12:14 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/5 "2021-12-02T12:14:20Z")

</div>

![Node mssql properties](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/c/2c44b756b5bf05712218a4de48eafc6f7ca2ae3a.png)

This is my problem. In the properties for editing the node, the parameters are not shown to me.

---

<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:** [2 December 2021 14:12 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/6 "2021-12-02T14:12:56Z")

</div>

Uninstall node-red-contrib-mssql  
Install node-red-contrib-mssql-plus  
Refresh browser.

---

<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:** [31 January 2022 14:13 UTC](https://discourse.nodered.org/t/how-can-i-change-mssql-connection-timeout-value/54573/7 "2022-01-31T14:13:37Z")

</div>

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