# IOT2000-Node Red MSSQL ConnectionError

**URL:** <https://discourse.nodered.org/t/iot2000-node-red-mssql-connectionerror/11506>\
**Category:** General\
**Created:** [24 May 2019 13:47 UTC](https://discourse.nodered.org/t/iot2000-node-red-mssql-connectionerror/11506 "2019-05-24T13:47:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BartosIstvan](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@BartosIstvan](https://discourse.nodered.org/u/BartosIstvan)\
**Post date:** [24 May 2019 13:47 UTC](https://discourse.nodered.org/t/iot2000-node-red-mssql-connectionerror/11506/1 "2019-05-24T13:47:40Z")

</div>

Hello! I have connected my pc via shh to my IOT2000 on wich is running the Node-Red. I want to make a db connection on Node-Red to my database wich is on my Pc. I'm using node-red-contrib-mssql-plus.  
In the microsoft sql server configuration manager I have enabled all the necessary communication protocols. I set my db to allow login with user "sa" and a password.  
The server : the IP of my pc.  
 ![forum3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/c/cbe96bc44c49393c887e61e1d84b7c4229abce48.png)  
 ![forum1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/f/fa42929593219a273d5122ab3486ef09784d30b5.png)

 ![forum2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/7/7e33896847b0c73e6e5a6feaf46a2cc341290b39.png)

The same connection issue I have made it with MySQL, but here I'm getting trouble. I guess I have problem with user roles ?

---

<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:** [25 May 2019 18:12 UTC](https://discourse.nodered.org/t/iot2000-node-red-mssql-connectionerror/11506/2 "2019-05-25T18:12:57Z")

</div>

Check SQL server log and verify port 1433 is correct.  
Also I think you may need to enable TCP connection ?