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

**URL:** https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949
**Category:** General
**Tags:** node-red-contrib-mssql-plus
**Created:** [2 April 2024 20:36 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-02T20:36:51Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Manikandan](https://avatars.discourse-cdn.com/v4/letter/m/3da27b/32.png) [@Manikandan](https://discourse.nodered.org/u/Manikandan)
#### Post date: [2 April 2024 20:36 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949/1 "2024-04-02T20:36:51Z")

</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 ?

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

---

<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: [2 April 2024 20:44 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949/2 "2024-04-02T20:44:49Z")

</div>

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...

---

<div class="post-metadata">

### Author: ![Manikandan](https://avatars.discourse-cdn.com/v4/letter/m/3da27b/32.png) [@Manikandan](https://discourse.nodered.org/u/Manikandan)
#### Post date: [2 April 2024 21:07 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949/3 "2024-04-02T21:07:52Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/9/39b521227898e6d185e4a890e39ca1958e588c22.png)

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

Regards,  
Mani

---

<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: [2 April 2024 21:31 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-mssql-plus-node-to-access-the-db-through-proxy-server/86949/4 "2024-04-02T21:31:07Z")

</div>

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](https://stackoverflow.com/questions/6915472/accessing-sql-server-over-an-ssh-tunnel)

---

<div class="post-metadata">

### Author: ![Manikandan](https://avatars.discourse-cdn.com/v4/letter/m/3da27b/32.png) [@Manikandan](https://discourse.nodered.org/u/Manikandan)
#### Post date: [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/5 "2024-04-06T09:45:41Z")

</div>

Hello Steve-Mcl,

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

Regards,  
Mani

---

<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: [5 July 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/6 "2024-07-05T09:45:54Z")

</div>

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