Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED

sql-server node.js node-mssql tedious
Matt Carrier picture Matt Carrier · Aug 30, 2014 · Viewed 72.5k times · Source

I am trying to connect to MSSQL 2012 using NodeJS with the mssql connection interface.

When attempting to connect I get the following error:

{ [ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED]
  name: 'ConnectionError',
  message: 'Failed to conncet to localhost:1433 - connect ECONNREFUSED',
  code: 'ESOCKET' }

Any ideas on how to fix this?

Answer

Matt Carrier picture Matt Carrier · Aug 30, 2014

The solution is to enable TCP connections which are disabled by default.

enter image description here

Related questions

Node.js and Microsoft SQL Server

Is there any way I can get my Node.js app to communicate with Microsoft SQL? I haven't seen any MS SQL drivers out there in the wild? I'm putting a very simple app together and need to be able …

Read More
Connect to SQL Server with mssql for node.js

I got a error message when I connect to SQL Server with mssql module for node.js. [Error: connection to 192.168.1.101\sql:1433 - failed Error: getaddrinfo ENOENT] var config = { //driver: 'msnodesql', user: '...', password: '...', server: '192.168.1.101\\sql', //TCP/…

Read More
Using Node.js to connect to Microsoft SQL Server 2008 (MSSQL) database

Possible Duplicate: Connecting to a remote Microsoft SQL server from Node.js I'm looking for an up-to-date explanation of how to connect to a MS SQL Sever 2008 using Node.js (v0.5.7) I have tried both Node.js projects on GitHub …

Read More