Problem with install node-red-contrib-mssql-plus

Hello,

I have problem with install node-red-contrib-mssql-plus

2025-07-24T07:10:29.932Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --omit=dev --engine-strict node-red-contrib-mssql-plus@0.13.1
2025-07-24T07:10:33.775Z [err] npm 
2025-07-24T07:10:33.775Z [err] ERR! code EBADENGINE
2025-07-24T07:10:33.778Z [err] npm ERR! engine
2025-07-24T07:10:33.778Z [err]  Unsupported engine
2025-07-24T07:10:33.778Z [err] npm ERR! 
2025-07-24T07:10:33.778Z [err] engine Not compatible with your version of node/npm: @azure/core-auth@1.10.0
2025-07-24T07:10:33.779Z [err] npm 
2025-07-24T07:10:33.779Z [err] ERR! notsup Not compatible with your version of node/npm: @azure/core-auth@1.10.0
2025-07-24T07:10:33.779Z [err] npm ERR! notsup
2025-07-24T07:10:33.779Z [err]  Required: {"node":">=20.0.0"}
2025-07-24T07:10:33.779Z [err] npm ERR! notsup Actual:   {"npm":"9.2.0"}
2025-07-24T07:10:33.782Z [err] 
2025-07-24T07:10:33.782Z [err] npm ERR! A complete log of this run can be found in:
2025-07-24T07:10:33.782Z [err] npm ERR!
2025-07-24T07:10:33.782Z [err]      /root/.npm/_logs/2025-07-24T07_10_30_348Z-debug-0.log
2025-07-24T07:10:33.796Z rc=1

Node-Red version: 4.0.9:
Operation system: Ubuntu 24.04.2 LTS
Node.js version: v22.17.1
npm version: 10.9.2

Please help to fix it.

I suspect you are using n or nvm or fnm or another node manager & the actual version of Node you are running node-red with is < v20. To prove this, open the "System Info" on your node-red editor:

chrome_q8PiepPq74


Additionally, please clarify how you installed Node-RED and how you run it? It looks like you are running Node-RED as root - this is REALLY not advisable.

    "nodejs": {
        "version": "v18.19.1",
        "arch": "x64",
        "platform": "linux",
        "memoryUsage": {
            "rss": 129437696,
            "heapTotal": 56156160,
            "heapUsed": 50273200,
            "external": 4251038,
            "arrayBuffers": 226344
        }
    },

Are you running node-red as root? That is almost always a bad idea. I don't know if it is to do with your problem or not.

Did you install node-red using the recommended method for Ubuntu?

Yes, start as root

How I will change node.js version?

@Oleg

You have 2 issues.

  1. You have some kind of node version manager installed & that is confusing the situation and causing the MSSQL node installation issue. When you entered node -v it reported v20, but as you can clearly see from System Info, Node-RED is running on Node v18.
  2. You are running as root, again, unless you absoultely need root or understand the implications, you should run this as a regular user.

My recommendation to fix all of your issues.

  1. Remove n, nvm, fnm or any other Node Version manager you have installed
  2. Install Node-RED using the official installer script

Thank you. Try to fix it.