Do this 
Read this 
https://stackoverflow.com/questions/1339944/cant-connect-to-localhost-but-can-with-computer-name-in-sql-server-2008
. Cannot be used. Try 127.0.0.1\SQLEXPRESS03
If you use SSMS, does 127.0.0.1\SQLEXPRESS03 work?
Can you also try SSMS to 10.12.37.172\SQLEXPRESS03 does that work?
Also, check the Event Log to double check there are no TCP errors for instance SQLEXPRESS03 and also double check the PORT number it assigned
Also, i have said several times, I dont know if built in auth works - I ABSOLUTELY know that SQL Auth works.
does not work when I use 127.0.0.1\SQLEXPRESS03 and 10.12.37.172\SQLEXPRESS03
I asked you to try this in SSMS - Are you saying if you open SSMS (SQL Server Management Studio) that you CAN NOT connect to either 127.0.0.1\SQLEXPRESS03 or 10.12.37.172\SQLEXPRESS03 ?
how can i check if TCP errors for instance SQLEXPRESS03 and also double check the PORT number it assigned?
please confirm the previous question first.
i cant connect both of them ( 127.0.0.1\SQLEXPRESS03 or 10.12.37.172\SQLEXPRESS03)
do I can connect ./SQLEXPRESS03
ah, ok, so my fault.
Can you connect 127.0.0.1/SQLEXPRESS03 or 10.12.37.172/SQLEXPRESS03 from SSMS?
also i can connect by this (localdb)\MSSQLLocalDB
No, I can not connect with 127.0.0.1/SQLEXPRESS03 or 10.12.37.172/SQLEXPRESS03 from SSMS.
Could you try the following in NODE-RED MSSQL config settings...
- Verify PORT number for instance SQLEXPRESS03
- Connect SSMS to
.\SQLEXPRESS03 - enter the following...
USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on', N'any', NULL, NULL, N'asc'
GO
- Try with computer name only
- Set server to
DS(or whatever your host name is) - Set PORT to that found in logs
- Try with Loopback IP only
- Set server to
127.0.0.1 - Set PORT to that found in logs
- Try with Computer IP only
- Set server to
10.12.37.172 - Set PORT to that found in logs
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
