Good! So far we have...
- Port number is:
1433
- Instance name is:
SQLEXPRESS03
Now show me the MSSQL config node settings
Also, remember to delete ALL config nodes except 1
As I showed you...
- Select config
- click pencil
- click delete
- click done
- goto step 1 & do it again
1 Like
lol I delete them
Now if you put a SQL username and password in, Update & Deploy
then test a simple query something like ...
SELECT 1 as [one], GetDate() as [now]
What happens?
Is the SQL Server on the same computer as node-red?
If YES - try again with the server field set to 127.0.0.1\SQLEXPRESS03 in MSSQL Config
I am using Windows authorization so no need to put the user name and password.
Yes they are on the same PC.
Then try 127.0.0.1\SQLEXPRESS03
As I said below...
If node-red and the SQL server are on the same machine then the loopback address (127.0.0.1) should work.
Are you running any of these in docker?
Do you know what loopback address is? It is something built in to the OS.
127.0.0.1 means? It is (mostly) associated with localhost or THIS COMPUTER
Read up - localhost - Wikipedia.
So to answer your question -
No - it should work!
HOWEVER there is a BUT
Cannot advise until you answer
What do you mean by in docker, please?
Is node-red or SQL Server running in a Virtual Machine or a container or docker environment?
OR are node-red AND SQL Server both installed DIRECTLY in windows AND on the SAME windows computer?
Can you show me all entries in this list
The node-red AND SQL Server both installed DIRECTLY in windows AND on the SAME windows.
