I am using NodeRed verion v3.0.2 and Node.js version v18.14.2.
I want to connect NodeRed with my MSSQL (2019) DB but get the "login failed for user" error everytime. I tried everything (other users/passwords/reinstall/update/...) but still no connection possible.
NodeRed and the SQL DB are running on the same server so I am using localhost.
Anybody got an idea??
{"code":"ELOGIN","message":"Login failed for user 'NodeRed'.","details":"Login failed for user 'NodeRed'.","name":"ConnectionError"}
Have tried the IP, still no change.
Even the error code is the same.. so there should be no problem with localhost or am I thinking wrong?
In the SQL logs i find port 1433...
Protocols for the SQL Server?
They are all enabled. (Shahred Memory, Named Pipes, TCP/IP)
Also i can find this in the logs:
Date 28/02/2023 12:59:16
Log SQL Server (Current - 28/02/2023 12:53:00)
Source Logon
Message
Login failed for user 'NodeRed'. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only. [CLIENT: ::1]
But the user "NodeRed" already got nearly all rights (incl. admin for SQL)
OK now I think I got it... I had to make an additional change in the general server config... Earlier there was enough to change the properties for the additional user. Now I had to change the general server authentication...
Don't know if there would be an easier way but now it works.