Connection from node Red to MSSQL not working

Industrial
1

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 (1.5 KB)

SQLError

2

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?

3

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

Hi,

Im not very familiar with SQL actually.
Capture

Capture2
Capture21086×488 30.6 KB

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.

5

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