# Differences between node-red-contrib-mssql-plus in linux/windows?

**URL:** <https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061>\
**Category:** General\
**Created:** [29 August 2022 12:14 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061 "2022-08-29T12:14:12Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![OriolFM](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/oriolfm/32/30710_2.png) [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Post date:** [29 August 2022 12:14 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/1 "2022-08-29T12:14:12Z")

</div>

My main node-red (3.0) installation at work is on a CentOs VM. I am using node-red-contrib-mssql-plus v0.7.3 to access some MSSQL DBs and I have no problems.

I need to make some installs on a few PCs that will serve just as connected HMIs. I just made a fresh install on a test machine to make sure it works before deployment to the final machine. I used a windows VM, and just did a fresh node.js and node-red install, with the same versions I'm running on the other machine.

I am accessing both VMs from my laptop, within the local network. However, when I want to configure the base nodes for the DBs, there are substantial differences on what they show:

This is on the CentOS machine vs the Windows machine, side by side:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/8/583659d9ae2c4f551751013d317ab1da66888fbb.png) ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/c/1c7fe5753b58f699f58305e7812d9561686b34d5.png)

As you can see, the available options displayed are substantially different, with Windows showing less than half of the options.

Any idea of what might be the cause? as I said, the node-red and the node versions are the same on both machines.

---

<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:** [29 August 2022 13:52 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/2 "2022-08-29T13:52:36Z")

</div>

> [@OriolFM](#):
>
> Any idea of what might be the cause

You probably have the old node-red-contrib-mssql node installed. The plus version is a fork because that old version is abandoned.

Uninstall any other MSSQL node, restart & refresh browser.

---

<div class="post-metadata">

**Author:** ![SandeepA](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sandeepa/32/63225_2.png) [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Post date:** [29 August 2022 14:13 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/3 "2022-08-29T14:13:23Z")

</div>

> [@OriolFM](#):
>
> As you can see, the available options displayed are substantially different, with Windows showing less than half of the options.

FYI - I am using the plus node on Linux and Windows. Don't see such issues.

---

<div class="post-metadata">

**Author:** ![OriolFM](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/oriolfm/32/30710_2.png) [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Post date:** [29 August 2022 14:45 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/4 "2022-08-29T14:45:08Z")

</div>

Actually, it was the mssql-plus one. Same version.

I think I figured it out, it might have had something to do with the installation. Whenever I installed from the palette manager, this would happen and options would be missing.

I deleted everything, stopped node-red, and then installed the package using npm, from a powershell window running as admin.

Installation was successful, and when I restarted node-red everything was as expected.

---

<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:** [29 August 2022 15:02 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/5 "2022-08-29T15:02:10Z")

</div>

> [@OriolFM](#):
>
> Whenever I installed from the palette manager, this would happen and options would be missing

Only if you already have to old (non plus) version

> [@OriolFM](#):
>
> I deleted everything

Deleted what? Flows? Node\_modules? .node-red folder? Node-red?

> [@OriolFM](#):
>
> and then installed the package using npm, from a powershell window running as admin.

Installing nodes without `-g` does not and should not be ran as admin.  
And, installing from npm is exactly what the palette manager does.

---

<div class="post-metadata">

**Author:** ![OriolFM](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/oriolfm/32/30710_2.png) [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Post date:** [29 August 2022 16:01 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/6 "2022-08-29T16:01:08Z")

</div>

I had the plus version. Exactly the same as in my other environment.

It was a clean install, so I only had an inject node, the mssql and a debug node. I deleted the mssql-plus package also from the palette manager after deleting the node and configuration node.

I opened an admin powershell and run the npm command as specified on the node description, and it worked. I don't know why, I'm just saying what I did.

---

<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:** [29 August 2022 17:03 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/7 "2022-08-29T17:03:11Z")

</div>

> [@OriolFM](#):
>
> I had the plus version.

Steve is suggesting that you possibly had _both_ the original and the plus version installed.

---

<div class="post-metadata">

**Author:** ![OriolFM](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/oriolfm/32/30710_2.png) [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Post date:** [29 August 2022 17:52 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/8 "2022-08-29T17:52:22Z")

</div>

Not at the same time, I made a mistake installing first, but then uninstalled it before installing the plus version.

In any case, it works now.

---

<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:** [29 August 2022 18:13 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/9 "2022-08-29T18:13:47Z")

</div>

The way npm delivers a package is everything at once (in a tgz) - there is no possibility of it grabbing the wrong config node. However, what I have witnessed is when another fork (named alphabetically before node-red-contrib-mssql-plus) is that the plus version picks up the config node of the non plus version. Which is why I suggested you might have the old version installed.

> [@OriolFM](#):
>
> I made a mistake installing first, but then uninstalled it before installing the plus version

Then it is likely you didn't restart node-red or the browser wasn't fully refreshed

---

<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:** [12 September 2022 18:14 UTC](https://discourse.nodered.org/t/differences-between-node-red-contrib-mssql-plus-in-linux-windows/67061/10 "2022-09-12T18:14:12Z")

</div>

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