# Connection from node Red to MSSQL not working

**URL:** <https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529>\
**Category:** Industrial\
**Created:** [30 June 2022 07:33 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529 "2022-06-30T07:33:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dinesh](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@dinesh](https://discourse.nodered.org/u/dinesh)\
**Post date:** [30 June 2022 07:33 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529/1 "2022-06-30T07:33:15Z")

</div>

I am trying to connect node red to MSSQL but it is giving error:"ConnectionError: Login failed for user 'Administrator'."

My node red is in a separate device while the database is in PC but connected via ethernet.

I have tried with both node red and database in the same PC but it still give the same error .

Any reason why?

thank you  
[flows (44).json](https://discourse.nodered.org/uploads/short-url/qJLyksY3W0O0xzw5hgjagTmfjM4.json) (1.5 KB)

![SQLError](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/7/c7ee287528362b57e241344c2e615e896983e5c1.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [30 June 2022 08:54 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529/2 "2022-06-30T08:54:09Z")

</div>

Are you sure you have the correct user/password to connect to MSSQL?  
I’m not a MSSQL user but do you have to have authorization in MSSQL for the remote connection?

---

<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:** [30 June 2022 08:58 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529/3 "2022-06-30T08:58:21Z")

</div>

Are you using SQL authentication?

Can you verify the SQL username and password wourk using some other program (i.e. sql server management studio)

Can the machine running node-red ping the MSSQL computer 192.168.38.83?

Which SQL Node are you using ...

- node-red-contrib-mssql?
- node-red-contrib-mssql-plus?
- another?

---

<div class="post-metadata">

**Author:** ![dinesh](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@dinesh](https://discourse.nodered.org/u/dinesh)\
**Post date:** [1 July 2022 02:24 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529/4 "2022-07-01T02:24:37Z")

</div>

Hi,

Im not very familiar with SQL actually.  
 ![Capture](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/9/f90b7a0c3e1126ec5ce8e98a690960185e7a2fba.png)

 ![Capture2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/a/4a95c0d5231990ee9497b4697d370ce88c432ea8.png)

As per the image, this is what I set. For username and password, I have tried different variation of what is shown here.

I can ping the pc. I have also tried both db and node red in same pc but still same  
I am using node-red-contrib-mssql.

---

<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:** [30 August 2022 02:25 UTC](https://discourse.nodered.org/t/connection-from-node-red-to-mssql-not-working/64529/5 "2022-08-30T02:25:27Z")

</div>

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