# Error connecting to local MSSQL Server
**URL:** https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767
**Category:** General
**Created:** [7 May 2024 07:58 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767 "2024-05-07T07:58:03Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@jctamy](https://discourse.nodered.org/u/jctamy)
#### Post date: [7 May 2024 07:58 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/1 "2024-05-07T07:58:03Z")
Hi folks,
I have a problem trying to connect to a MSSQL Server hosted in the same host to Node-Red.
Node MSSQL outputs this error:
`ConnectionError: Failed to connect to 127.0.0.1:undefined in 15000ms`
This is the SQL node configuration:
What is wrong?
Best Regards!
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [7 May 2024 08:44 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/2 "2024-05-07T08:44:07Z")
You server doesnt look quite right. I realise it is a sql express but still, it doesnt look right.
So, regarding SQL instances: they don't (usually) appear on port 1433 like full installations. If you check the SQL logs you should find the correct port & you can use that in the config.
See this thread: [Problem connecting to mssql express · Issue #63 · bestlong/node-red-contrib-mssql-plus · GitHub](https://github.com/bestlong/node-red-contrib-mssql-plus/issues/63#issuecomment-1068399367)
The server would simply be your IP or hostname, the port would be the correct port SQL server opened
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [7 May 2024 09:01 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/3 "2024-05-07T09:01:20Z")
Another thing I have just realised you are using the old (unsupported, severely out of date) mssql nodes.
My advice was related to the much more capable and up-to-date node-red-contrib-mssql-plus nodes
---
### Author:  [@Ilkka](https://discourse.nodered.org/u/Ilkka)
#### Post date: [7 May 2024 09:24 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/4 "2024-05-07T09:24:16Z")
First of all, if you look Sql Server Configuration Manager, is your TCP/IP protocol enabled and configured to port 1433?
It has some time when I'm last time used Express, but you could try just address 127.0.0.1.
---
### Author:  [@jctamy](https://discourse.nodered.org/u/jctamy)
#### Post date: [28 June 2024 11:04 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/5 "2024-06-28T11:04:03Z")
Thank you all folks. Problem solved
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [26 September 2024 11:04 UTC](https://discourse.nodered.org/t/error-connecting-to-local-mssql-server/87767/6 "2024-09-26T11:04:42Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.