Connection with database error

General
1

"ConnectionError: Login failed for user 'sa'."

getting this eeror i have created a databse name RFID_ENTRIES1 ,and i am sending my data through mqtt node and data is getting correctly but i have to compare this data to my database ,i dont know why this error is coming?please help.

2

Hi @shipra

In order to help we need some more information.

You have not told us what database technology you are using or what Node-RED node module you have installed to connect to the database.

The error says you have the login details for the database wrong. At this point, that's all we can say.

3

yes ,i have taken mssql as database and node-red-contrib-mssql this as a node module

image
image1366Ă—768 173 KB

4

Actually Sir I want to compare my MQTT RFID data with my database ,so how to do that ,please help me.Thank You

5

So does this mean you have figured out how to connect to the database?

To compare data from two different places, you need to get the data into the same msg. In your case, you are sending data fron the RFID mqtt-in node to the mssql node. Put a debug node (set to displau the Complete msg object) on the output of both th e two nodes. Then you can see what the data looks like after exiting the mssql node.

I imagine that the mssql node will over write the msg.payload, so you will probably need to add a change node, between the two nodes, to copy the original msg.payload to another msg variable. Then in the output of the mssql node you should see all the information and be able to do what ever compares you need.

6

Hi, can I first recommend that you remove that node and instead install node-red-contrib-mssql-plus.

That node has not been updated in a long time and has known issues.

The one I recommend has active development, numerous bug fixes & many useful additional features.

7

ok ,Actually i am new to node red and mssql ,so if you could send me with wriiten samples or pictures i can try this out.please help

8

Also, node-red-contrib-mssql-plus had built in examples and detailed documentation.

1 Like
9

Ok please if anyone could send me with demo or screenshots it would be a great help .Thank You.

10

If you use the node I suggest and you fail to get it working, I will help you.

11

Thank You @zenofmud ,Actually i am new to node red and mssql please if you can send me screenshots then it would be a great help.Thank You

12

i have installed mysql server instead of mssql because i was stucked in that from past 2 days ,so just modifying my doubt to how to establish connection with mysql server with node red

13

Have you taken the advice @Steve-Mcl has given you?

14

yes,i am trying to follow but as i am new so clear picture I am not getting

15

Mysql is a completely different database so none of the MSSQL nodes will work.

16

ya ,i have shifted this to different database ,now this time i want guidance so that error would not ocuur

17

Install mysql node not MSSQL nodes.

19

Now use that one in your flow instead of MSSQL node.

20

Anyone please tell how to read and verify my mqtt rfid no with my database rfid no please tell,as this node red platform has limitation on number of queries so I have to get the solution in quick manner.
I am really looking for solution as i want to learn more.
thank you

21

Have you succeeded in connecting to the database from node-red?
Also which database type are you using?