# Error connecting to Database (MSSQL)

**URL:** https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598
**Category:** General
**Created:** [1 February 2022 15:09 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598 "2022-02-01T15:09:14Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![rathishhere](https://avatars.discourse-cdn.com/v4/letter/r/9fc29f/32.png) [@rathishhere](https://discourse.nodered.org/u/rathishhere)
#### Post date: [1 February 2022 15:09 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598/1 "2022-02-01T15:09:14Z")

</div>

"ConnectionError: Login failed for user ''." is the error i get when i try to connect to the database can anyone help

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/3/d32937f52a2b04c67063d90c7a3b25daa8b2f3af.png)

---

<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: [1 February 2022 16:17 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598/2 "2022-02-01T16:17:03Z")

</div>

Hi, welcome to the forum.

When posting a question it helps to include certain info that may prove useful to someone helping you...

- What node-js version are you using (`node -v`)
- What node-red version are you running
- where is node-red running (on a PI, Windows, Mac etc)

Can you also please answer...

- Which SQL node are you using (node-red-contrib-mssql-plus is recommended / most actively supported, most features)
- What SQL version are you attempting to connect to?
- Have you enabled SQL Login or are you trying to use integrated login.

---

<div class="post-metadata">

### Author: ![rathishhere](https://avatars.discourse-cdn.com/v4/letter/r/9fc29f/32.png) [@rathishhere](https://discourse.nodered.org/u/rathishhere)
#### Post date: [1 February 2022 16:41 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598/3 "2022-02-01T16:41:49Z")

</div>

Hi  
Im using the below versions  
Node.js v16.13.2.  
Node-RED version: v2.1.4  
Windows\_NT 10.0.19042 x64 LE

I used the node-red-contrib-mssql node  
Microsoft SQL SERVER 17  
Integrated Login  
Thanks

---

<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: [1 February 2022 19:32 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598/4 "2022-02-01T19:32:29Z")

</div>

> [@rathishhere](#):
>
> Microsoft SQL SERVER 17  
> Integrated Login

That node is abandoned. uninstall it and try the `node-red-contrib-mssql-plus` version.

Also, i am unsure about integrated login (SQL logins definitely work)

---

<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: [2 April 2022 19:33 UTC](https://discourse.nodered.org/t/error-connecting-to-database-mssql/57598/5 "2022-04-02T19:33:12Z")

</div>

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