nodejs with mssql connection timeout error

Question

I am writing a node.js console app for communicating with SQL Server 2008.

var sql = require('mssql');
var connection = new sql.Connection({
    user: 'sa',
    password: 'password',
    server: 'localhost\\SQLEXPRESS',
    database: 'Demo'
});

connection.connect(function (err) {
     if (err) console.log(err);

    var request = new sql.Request(connection); // or: var request = connection1.request();
    request.query('select * from EmpInfo', function (err, recordset) {
        // ... error checks

        console.dir(recordset);
    })
});

When I execute this code, a TIMEOUT error occurs.

Solution 1

１．you have to run "SQL Server Browser" service.

---

２．enable "TCP/IP"

*you need restart "SQLEXPRESS" service

---

it also helps bellow error.

ConnectionError: Port for SQLEXPRESS not found in "ServerName"

Solution 2

Maybe your query takes too long. Try to do SELECT 1 a. If it works - change the timeout. Doc for requestTimeout:

Solution 3

Actually It was error from "Sql Server Configuration Manager". Tcp\Ip was disabled in Sql server network configuration.