How to use node-red-contrib-mssql-plus node to access the DB through Proxy Server?

General
1

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 ?

Is there any way i can still use the same node to access the DB through Proxy Server or I must consider changing into different node ?
your inputs highly appreciated.

Regards,
Mani

2

So long as the proxy permits access from your node-red server, there is no reason it shouldn't work. So long as the IP and TCP port are accessable over the proxy...

3

Hi Steve-Mci,

Thanks for your quick response.

I was having an impression that, I must get configure a setting similar 'node-red : http request' node
Attached the proxy setting configuration available for the 'node-red : http request' node.

image

Could you kindly confirm if having the Proxy server configured to allow the Node-RED server would prevent any potential issues?

Regards,
Mani

4

Oh right I see. It all depends on the kind of proxy and how it is configured, whether there are local lan NO_PROXY settings etc. worst case, you may need to setup a reverse proxy or ssh tunnel

5

Hello Steve-Mcl,

Thanks for your suggestion and the link , I will explore both the options and will provide the feedback.

Regards,
Mani