# \#node-red-contrib-mssql-plus

**URL:** https://discourse.nodered.org/tag/node-red-contrib-mssql-plus/67.md

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

---

## [MSSQL node - Incorrect syntax near ','](https://discourse.nodered.org/t/mssql-node-incorrect-syntax-near/98910)

<div class="topic-metadata">

**Author:** [@lev36](https://discourse.nodered.org/u/lev36)\
**Replies:** 13\
**Last updated:** [2 September 2025 13:39 UTC](https://discourse.nodered.org/t/mssql-node-incorrect-syntax-near/98910 "2025-09-02T13:39:35Z")

</div>

I am trying to write some data in SQL server via MSSQL node. I connected the node to the server and in the flow correctly, written the query in editor mode, but when I deploy the flow, it sends back the error: “Incorrect…

---

## [Form node: mistake on output of two date fields](https://discourse.nodered.org/t/form-node-mistake-on-output-of-two-date-fields/96754)

<div class="topic-metadata">

**Author:** [@jumpier](https://discourse.nodered.org/u/jumpier)\
**Replies:** 9\
**Last updated:** [26 April 2025 09:39 UTC](https://discourse.nodered.org/t/form-node-mistake-on-output-of-two-date-fields/96754 "2025-04-26T09:39:42Z")

</div>

Hi to everybody. i've insert a form node with 2 date fileds ("start" and "end" fileds). Then insert 2 date: start = 24/04/2025 end = 25/04/2025 The debug node, showing 1 day less Any idea? Thanks a lot

---

## [Execute SQL Query from an array object](https://discourse.nodered.org/t/execute-sql-query-from-an-array-object/94446)

<div class="topic-metadata">

**Author:** [@Mabona745](https://discourse.nodered.org/u/Mabona745)\
**Replies:** 4\
**Last updated:** [9 January 2025 08:55 UTC](https://discourse.nodered.org/t/execute-sql-query-from-an-array-object/94446 "2025-01-09T08:55:19Z")

</div>

Hi Everyone, i'm new to node-red, can anyone help me with this, i'm trying to load get data from Servicely Api and load it to SQL table, i'm trying to run the query which come from an array object, i'm getting the "Requ…

---

## [Connection Timeout in Node-Contrib MS-SQL-PLUS](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079)

<div class="topic-metadata">

**Author:** [@bobfield](https://discourse.nodered.org/u/bobfield)\
**Replies:** 5\
**Last updated:** [11 November 2024 22:22 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079 "2024-11-11T22:22:04Z")

</div>

Hi Dears, I have a node-red program accessing a cloud database with node-contrib ms-sql-plus. Everything works perfectly on my machine, but when I take it to the client it cannot connect and it gives a timeout. His mach…

---

## [SQL SERVER Node](https://discourse.nodered.org/t/sql-server-node/92155)

<div class="topic-metadata">

**Author:** [@LucasPelu](https://discourse.nodered.org/u/LucasPelu)\
**Replies:** 9\
**Last updated:** [4 October 2024 14:05 UTC](https://discourse.nodered.org/t/sql-server-node/92155 "2024-10-04T14:05:22Z")

</div>

Hello, I am working with SQL Server and I need to make a query using Node Red so that it brings me information from a table. my script is the following: select \* from alc.ActivityType where ActivityTypeName = 'variable…

---

## [Does Node Red requires TLS1.2 as a pre-requisites to connect to SQL DB?](https://discourse.nodered.org/t/does-node-red-requires-tls1-2-as-a-pre-requisites-to-connect-to-sql-db/90304)

<div class="topic-metadata">

**Author:** [@AlokPatil](https://discourse.nodered.org/u/AlokPatil)\
**Replies:** 2\
**Last updated:** [26 August 2024 16:07 UTC](https://discourse.nodered.org/t/does-node-red-requires-tls1-2-as-a-pre-requisites-to-connect-to-sql-db/90304 "2024-08-26T16:07:24Z")

</div>

Hello NodeRed Users/Developers, We have SCADA application which generates high frequency alarms/events and stores in local SQL database. 1. We would like to know whether Node-RED module requires TLS 1.2 as a pre-requisi…

---

## [How to use MSSQL setup with environment variables and Project History](https://discourse.nodered.org/t/how-to-use-mssql-setup-with-environment-variables-and-project-history/89703)

<div class="topic-metadata">

**Author:** [@jhamel](https://discourse.nodered.org/u/jhamel)\
**Replies:** 0\
**Last updated:** [23 July 2024 13:58 UTC](https://discourse.nodered.org/t/how-to-use-mssql-setup-with-environment-variables-and-project-history/89703 "2024-07-23T13:58:02Z")

</div>

I have a situation that baffles me and I am in need of anyone who knows what would be the best solution. I have 3 environments (DEV, TEST, LIVE). I use node-red-contrib-mssql-plus setup with environment variables for S…

---

## [Node-red-contib-mssql-plus](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042)

<div class="topic-metadata">

**Author:** [@jctamy](https://discourse.nodered.org/u/jctamy)\
**Replies:** 1\
**Last updated:** [28 June 2024 14:21 UTC](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042 "2024-06-28T14:21:41Z")

</div>

Hi folks, I was experimentating some problems with palette node-red-contrib-mssql. Then I saw that any update was made in 7 years ago. So now I have upgrade to plus mssql palette, and shows me this error: Insert query: …

---

## [Help loading Byte Array for SQL insert](https://discourse.nodered.org/t/help-loading-byte-array-for-sql-insert/88843)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 4\
**Last updated:** [21 June 2024 20:30 UTC](https://discourse.nodered.org/t/help-loading-byte-array-for-sql-insert/88843 "2024-06-21T20:30:41Z")

</div>

Happy Friday to all. I am using OpenAI to do some analysis on a photo taken by a RPi camera. With the help provided in this post, I got that all figured out by using a function node. Now I wish to send several pieces …

---

## [Hello everyone I need some help about mssql-plus](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111)

<div class="topic-metadata">

**Author:** [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Replies:** 11\
**Last updated:** [20 May 2024 07:30 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111 "2024-05-20T07:30:30Z")

</div>

I want to use mssql-plus to connect to the SQL server database, but I can't connect all the time, and the request times out. This is the error message: {"code":"ETIMEOUT", "message":"Failed to connect to 192.168.28.1\\\\…

---

## [How to use node-red-contrib-mssql-plus node to access the DB through Proxy Server?](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949)

<div class="topic-metadata">

**Author:** [@Manikandan](https://discourse.nodered.org/u/Manikandan)\
**Replies:** 4\
**Last updated:** [6 April 2024 09:45 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949 "2024-04-06T09:45:41Z")

</div>

Hi, I my project I am using node-red-contrib-mssql-plus node to insert and retrieve the data from the MS-SQL. It's been working fine more than a year now. Now I have requirement to access the DB through Proxy server ? …

---

## [Node-red-contrib-mssql-plus 0.12.2 EREQUEST/Invalid string error](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-0-12-2-erequest-invalid-string-error/85761)

<div class="topic-metadata">

**Author:** [@berzezo](https://discourse.nodered.org/u/berzezo)\
**Replies:** 2\
**Last updated:** [22 February 2024 10:41 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-0-12-2-erequest-invalid-string-error/85761 "2024-02-22T10:41:47Z")

</div>

Hello, Can anybody help me about debugging the following error. I tried with different data types, but I couldn't find out where the problem is after many hours. This was a working solution until I updated the mssql-p…

---

## [Mssql not sending data to database using mustache format](https://discourse.nodered.org/t/mssql-not-sending-data-to-database-using-mustache-format/83527)

<div class="topic-metadata">

**Author:** [@Hugror](https://discourse.nodered.org/u/Hugror)\
**Replies:** 7\
**Last updated:** [8 December 2023 15:16 UTC](https://discourse.nodered.org/t/mssql-not-sending-data-to-database-using-mustache-format/83527 "2023-12-08T15:16:25Z")

</div>

Hello there, I'm trying to send some data to my database with MSSQL. I achieved to send data using the node, but when I need to send data from the flow, it is not working. I have OPCUA node that retrieves a bool, and i…

---

## [Node-red-contrib-mssql-plus fails to install because of version mismatch?](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 7\
**Last updated:** [21 November 2023 10:05 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040 "2023-11-21T10:05:19Z")

</div>

Hi, I really need node-red-contrib-mssql-plus because it is a very basic node in most of my flows. But after upgrading Node-Red and all of its basic infrastructure nike NPM and Node.js I cannot re-install this node, al…

---

## [Node-red-contrib-mssql-plus 0.11.0 missing UI](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-0-11-0-missing-ui/81621)

<div class="topic-metadata">

**Author:** [@rjm21](https://discourse.nodered.org/u/rjm21)\
**Replies:** 2\
**Last updated:** [28 September 2023 15:38 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-0-11-0-missing-ui/81621 "2023-09-28T15:38:31Z")

</div>

I have two identical machines using node-red to take values from a PLC and store in MSSQL using the MSSQL-PLUS node. On one machine, node-red-contrib-mssql-plus is at 0.10.2. The other is updated to 0.11.0. The node ed…

---

## [Node-red-contrib-mssql-plus applicationIntent in connection string](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-applicationintent-in-connection-string/81196)

<div class="topic-metadata">

**Author:** [@JL40](https://discourse.nodered.org/u/JL40)\
**Replies:** 1\
**Last updated:** [12 September 2023 06:11 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-applicationintent-in-connection-string/81196 "2023-09-12T06:11:48Z")

</div>

Hello, I'm using node-red-contrib-mssql-plus Is there an option to add additionnal parameters in the connection string? I need to add "ApplicationIntent=ReadOnly"

---

## [MSSQL-PLUS Execute Procedure](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377)

<div class="topic-metadata">

**Author:** [@Mohamed\_1711](https://discourse.nodered.org/u/Mohamed_1711)\
**Replies:** 3\
**Last updated:** [11 August 2023 23:46 UTC](https://discourse.nodered.org/t/mssql-plus-execute-procedure/80377 "2023-08-11T23:46:34Z")

</div>

I Have function before my MSSQL-PLUS I want to send to MSSQL-PLUS the procedure Name : ProductNodeRedService And this procedure has 3 parameters and 2 return Value : Paramter\_Number\_1 Type: NVARCHAR(MAX) Paramter\_Nu…

---

## [Error by installing MSSQL-Plus (Error: package: '@azure/msal-node@1.18.0)](https://discourse.nodered.org/t/error-by-installing-mssql-plus-error-package-azure-msal-node-1-18-0/79878)

<div class="topic-metadata">

**Author:** [@kappo73](https://discourse.nodered.org/u/kappo73)\
**Replies:** 6\
**Last updated:** [17 July 2023 14:02 UTC](https://discourse.nodered.org/t/error-by-installing-mssql-plus-error-package-azure-msal-node-1-18-0/79878 "2023-07-17T14:02:08Z")

</div>

Hi During trying to change my MSSQL packages from "node-red-contrib-mssql" to node-red-contrib-mssql-plus there always appear errors like below: xxxxx@xxxmqtt:~/.node-red$ npm install node-red-contrib-mssql-plus …

---

## [SQL Receiving Only 0 or NULL from MSSQL-PLUS Node](https://discourse.nodered.org/t/sql-receiving-only-0-or-null-from-mssql-plus-node/78128)

<div class="topic-metadata">

**Author:** [@rjm21](https://discourse.nodered.org/u/rjm21)\
**Replies:** 15\
**Last updated:** [5 May 2023 16:17 UTC](https://discourse.nodered.org/t/sql-receiving-only-0-or-null-from-mssql-plus-node/78128 "2023-05-05T16:17:30Z")

</div>

\[{"id":"22e38406c0cea71d","type":"tab","label":"Flow 2","disabled":false,"info":"","env":\[\]},{"id":"b063d1b663175b51","type":"modbus-read","z":"22e38406c0cea71d","name":"LOCATION","topic":"","showStatusActivities":false,…

---

## [How to use MS-SQL BULK Import?](https://discourse.nodered.org/t/how-to-use-ms-sql-bulk-import/77484)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 4\
**Last updated:** [12 April 2023 09:33 UTC](https://discourse.nodered.org/t/how-to-use-ms-sql-bulk-import/77484 "2023-04-12T09:33:02Z")

</div>

Hi all, we are trying to use the mssql BULK import feature, but we are failing due to an error that we are not able to find. This is the table we want to write our data to: The first column, ValueFloat\_ID is an auto…

---

## [How Get or Read data from SQL Server in node red?](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480)

<div class="topic-metadata">

**Author:** [@riimeister](https://discourse.nodered.org/u/riimeister)\
**Replies:** 3\
**Last updated:** [12 April 2023 09:24 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480 "2023-04-12T09:24:06Z")

</div>

Hi everyone, How to read or pull data from sql server on node red? If I send data I understand, but if I pull data from a table on the SQL server database, I have never done that. sample data I want to read or pull T…

---

## [Node red on RPi refuse to connect to MySQL DB running on another RPi on local LAN](https://discourse.nodered.org/t/node-red-on-rpi-refuse-to-connect-to-mysql-db-running-on-another-rpi-on-local-lan/76990)

<div class="topic-metadata">

**Author:** [@fritserasmus](https://discourse.nodered.org/u/fritserasmus)\
**Replies:** 14\
**Last updated:** [28 March 2023 07:39 UTC](https://discourse.nodered.org/t/node-red-on-rpi-refuse-to-connect-to-mysql-db-running-on-another-rpi-on-local-lan/76990 "2023-03-28T07:39:13Z")

</div>

I have my Node-RED on a RPi 192.168.1.23 and MySQL on another RPi 192.168.1.24 I used to have Node-RED, MQTT server and MySQL DB server on one RPi , but it struggled so I am splitting it up to two RPi with Node-RED and …

---

## [List the db connections in MSSQL-CN](https://discourse.nodered.org/t/list-the-db-connections-in-mssql-cn/76283)

<div class="topic-metadata">

**Author:** [@NoobX](https://discourse.nodered.org/u/NoobX)\
**Replies:** 1\
**Last updated:** [8 March 2023 11:37 UTC](https://discourse.nodered.org/t/list-the-db-connections-in-mssql-cn/76283 "2023-03-08T11:37:14Z")

</div>

Hello Everyone ! I have quite a few connections in MSSQL-CN, established with databases to use the MSSQL PLUS node. I would like to regularly check the list of these connections, as well as their properties: name , se…

---

## [ELOGIN; MSSQL Login failed](https://discourse.nodered.org/t/elogin-mssql-login-failed/75862)

<div class="topic-metadata">

**Author:** [@Markus712712](https://discourse.nodered.org/u/Markus712712)\
**Replies:** 6\
**Last updated:** [28 February 2023 12:21 UTC](https://discourse.nodered.org/t/elogin-mssql-login-failed/75862 "2023-02-28T12:21:12Z")

</div>

Hi, I am using NodeRed verion v3.0.2 and Node.js version v18.14.2. I want to connect NodeRed with my MSSQL (2019) DB but get the "login failed for user" error everytime. I tried everything (other users/passwords/reinst…

---

## [MSSQL Plus - New Feature Request - Allow creds on msg](https://discourse.nodered.org/t/mssql-plus-new-feature-request-allow-creds-on-msg/75025)

<div class="topic-metadata">

**Author:** [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Replies:** 1\
**Last updated:** [11 February 2023 09:57 UTC](https://discourse.nodered.org/t/mssql-plus-new-feature-request-allow-creds-on-msg/75025 "2023-02-11T09:57:37Z")

</div>

Hi , Is it possible to upgrade this node - such that if user/password/server/database/port - is defined on the msg (special attributes - msg.sqlsuser and so on ... ) - then the node - will take it from there - else cont…