Node-red-contrib-mssql-plus-0.12.2 - Failed to connect

General
1

Hi to everybody

i've try to open connection with local DB SQL Server Express Edition v2019 (the SQL Server is installed on the same computer where i execute Node-Red).

I've download and install a node-red-contrib-mssql-plus-0.12.2; then i try to the DB configure connection.

The server name are "NODE-RED\SQLEXPRESS", port 1433, table name "TblNodeRed". Then i've create a user: name and password equal to "nodered" (see the picuture).

The SQL firewall roules and port configuration may be ok (see the pictures).

Any idea? Thanks a lot

Error messages are show next to the first images

errcon
errcon1047×896 50.4 KB

errcon1
errcon11066×846 41.9 KB

firewall
firewall1367×568 34 KB

conf01
conf01926×682 20.3 KB

conf02
conf02940×630 18.2 KB

conf03
conf03944×714 21.8 KB

flow
flow898×180 6.01 KB

2

Yes. The SQL Express port is typically NOT 1433.

Check the instance logs to get the dynamically generated port number.

3

PS, just noticed you set the default port to 1433 so that might be ok (but still check SQL server logs)

More importantly, remove the instance name from the Server field. Also, instead of the DNS/WINS/HOST name, try using the IP of the machine running SQL Server. Something like 127.0.0.1 or 192.168.86.1.10 only.

Also, read the full threads I linked to (some valuable info in them).

4

Thank you Steve. I've change the server name from "NODE-RED\SQLEXPRESS" to "127.0.0.1" and now working fine