Error connecting to Database (MSSQL)

General
1

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

image
image1003×479 97.9 KB

2

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

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

4

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)

5

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