Hello everyone I need some help about mssql-plus

[Xiang]

I want to use mssql-plus to connect to the SQL server database, but I can't connect all the time, and the request times out.
This is the error message:

{"code":"ETIMEOUT",
"message":"Failed to connect to 192.168.28.1\\data in 15000ms",
"details":"Failed to connect to 192.168.28.1\\data in 15000ms",
"name":"ConnectionError"}

[Steve-Mcl]

Hi @Xiang welcome to the forum.

Please provide more detail:

Where is node-red and SQL server running? (Same computer? Windows? Linux??, in docker? Etc)

Is your SQL server a named instance?

Are you able to connect using ssms? (Show us what you enter to connect)

Show us what you have entered in the connection config on node-red.

[Xiang]

Both node-red and SQL server are running on the same computer, is windows.
SQL server can log in normally, including local login and account password, and can also be connected normally, I have tested it with Java.
I can connect with using ssms.

[Steve-Mcl]

Why have you added \data to the host name?

@Xiang

can connect with using ssms

Please show us as requested

@Steve-Mcl

(Show us what you enter to connect)

@Steve-Mcl

Is your SQL server a named instance

Please answer this

[Xiang]

And my SQL is a default instance

[Steve-Mcl]

I'm which case, the only issue I see is you added \data to the host. Remove that and try again.

Try unchecking Use Encryption too.

[Xiang]

I unticked 'Use Encryption?', 'Trust Certificate?' and 'Assume UTC?' and it work

[Steve-Mcl]

@Xiang

Assume UTC

Leave that ticked.

Also, did you remove \data from the server Field?

[Xiang]

Yes, I remove it.Thank you very much for your help.

[Xiang]

My classmate can run and he checked the Use Encryption. Can you tell me why? pls.

[Steve-Mcl]

The server part was the only problem as far as I can see. Try switching it back on.

[Xiang]

I forgot one detail, he added \data