# Node-red-contrib-mssql-plus fails to install because of version mismatch?

**URL:** <https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040>\
**Category:** General\
**Tags:** node-red-contrib-mssql-plus\
**Created:** [20 November 2023 19:09 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040 "2023-11-20T19:09:01Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gawan](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Post date:** [20 November 2023 19:09 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/1 "2023-11-20T19:09:02Z")

</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, all I get is this error message that drives me crazy 😰 😩 😤

2023-11-20T19:08:08.722Z [err] Not compatible with your version of node/npm: @azure/msal-node@1.18.4  
2023-11-20T19:08:08.722Z [err] npm ERR! notsup Not compatible with your version of node/npm: @azure/msal-node@1.18.4  
2023-11-20T19:08:08.722Z [err] npm ERR! notsup Required: {"node":"10 || 12 || 14 || 16 || 18"}  
2023-11-20T19:08:08.722Z [err] npm ERR! notsup Actual: {"npm":"10.1.0","node":"v20.9.0"}

What can I do ?  
BR  
Gawan

---

<div class="post-metadata">

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Post date:** [20 November 2023 19:17 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/2 "2023-11-20T19:17:02Z")

</div>

You upgraded to node.js v20, and according to the error message you have to have one of v10 - v18. Try v18

---

<div class="post-metadata">

**Author:** ![Gawan](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Post date:** [20 November 2023 19:25 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/3 "2023-11-20T19:25:28Z")

</div>

Is it possible to downgrade this under windows ?

I thought it is important to always have the most actual software for security and performance reasons !?!?

---

<div class="post-metadata">

**Author:** ![marcus-j-davies](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marcus-j-davies/32/103435_2.png) [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Post date:** [20 November 2023 19:33 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/4 "2023-11-20T19:33:21Z")

</div>

Ensuring you have the latest/stable Node version is indeed important to security, but that doesn’t stop node modules from enforcing versions.

You will need to address (which I believe, is too strict version control) with the node author of **@azure/msal-node**

You can install node version 18 using the windows node 18 installer.

You will need to run `npm rebuild` under your `.node-red` directory after downgrading.

I wouldn’t consider a system using node 18 to be in danger, some users prefer to be a major or 2 behind the latest

---

<div class="post-metadata">

**Author:** ![Gawan](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Post date:** [20 November 2023 19:45 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/5 "2023-11-20T19:45:49Z")

</div>

what does "downgrading" mean ?  
download version 18, install it and overwrite the existing one under windows ?

---

<div class="post-metadata">

**Author:** ![marcus-j-davies](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marcus-j-davies/32/103435_2.png) [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Post date:** [20 November 2023 19:49 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/6 "2023-11-20T19:49:05Z")

</div>

Yes - install node version 18 to replace node version 20

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [21 November 2023 09:46 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/7 "2023-11-21T09:46:17Z")

</div>

This has already been reported as an issue against the node. [Does not install with nodejs 20 (@azure/msal-node issue) · Issue #77 · bestlong/node-red-contrib-mssql-plus · GitHub](https://github.com/bestlong/node-red-contrib-mssql-plus/issues/77)

---

<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:** [21 November 2023 10:05 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/8 "2023-11-21T10:05:19Z")

</div>

If you can hang fire a wee while, `tedious` has [just merged](https://github.com/tediousjs/tedious/releases/tag/v16.6.1) node 20 support

That will filter through to the [node-mssql](https://github.com/tediousjs/node-mssql/issues/1540#issuecomment-1819423852) package soon (we hope)

Once it does, then mssql-plus will work under node20

---

<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:** [20 January 2024 10:06 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-fails-to-install-because-of-version-mismatch/83040/9 "2024-01-20T10:06:20Z")

</div>

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