setup mssql database pool connection with the node-mssql module

Question

I want to use a mssql database for my project. I took the node-mssql module (https://www.npmjs.com/package/mssql) and for the database management I use Microsoft SQL Server Management Studio 17.

When executing some queries I don't want to connect to the database multiple times so I want to create a pool to have a permanent connection to the database.

My database manager module:

const sql = require('mssql');
const db = require('../config/database.js');
const pool = new sql.ConnectionPool(db).connect();

My database configuration:

module.exports = {
    user: process.env.DB_USER || 'sa',
    password: process.env.DB_PASS || '-- myPassword --',
    server: process.env.DB_SERVER || 'localhost',
    database: process.env.DB || 'local_demo_cobra',
};

MSSQL Studio I changed the authentication mode to SQL Server Authentication

and here you can see the database managed by the server

When trying to run the code I get the error

ConnectionError: Failed to connect to localhost:1433 - Could not connect (sequence)

The database is running on my own system so using localhost should be fine. I also tried to change the server configuration to

server: process.env.DB_SERVER || 'localhost\\AP-MHERMSEN',

but this throws the same error

ConnectionError: Failed to connect to localhost\AP-MHERMSEN

What is wrong or missing?

Ruben_02041980 · Accepted Answer · 2019-04-11 06:24:02Z

1

+50

understand that you trying to connect to newly installed MSSQL locally. May you please check the below:

Ensure firewall port 1433 is open and listening. How to check > From CMD, type netstat -an
Launch SQL Server Configuration Manager, Expand SQL Server Network Configuration, Right-click Protocols for SQLEXPRESS, Right-click TCP/IP (ensure this is enabled), Under Tab IP Addresses, scroll down look for IPAll at the bottom, Ensure TCP Port is configured to 1433.
Ensure SQL Browser service is running.

Let me know if you stuck in any steps.

answered Apr 11, 2019 at 6:24

Ruben_02041980

863 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user9945420 Over a year ago

Hey there, thanks for your response. I added Port 1433 to my firewall. I enabled TCP/IP via Configuration Manager and the SQL Browser is set to automatic. But I can't find the Tab IP / IPALL

Ruben_02041980 Over a year ago

Please use below link and assign the port.Scroll down the TCP/IP Properties>IP Addresses tab until bottom. blog.sqlauthority.com/2018/07/24/…

Ruben_02041980 Over a year ago

Still same? Did you try restart the service before re-try again?

Collectives™ on Stack Overflow

setup mssql database pool connection with the node-mssql module

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related