How to change default port 1433 on SQL Server in a node.js connection string

Question

I changed the default port 1433 on my SQL Server in centos 7. But in API that is created with Node.js and uses the mssql package to connect to it, I get the error shown here when I want to send or get a request. mssql knows 1433 port as default.

My connection string

var sql = require('mssql');

var DbConnectionString = {
        user: 'sa',
        password: 'mypassword',
        server: 'serverip,newport',
        database: 'databasename',
    "options": {
    "encrypt": false,
    "enableArithAbort": true
    },    
};

module.exports = DbConnectionString;

And this is the error I get:

{
    "code": "ESOCKET",
    "originalError": {
        "message": "Failed to connect to myserverip,mynewport:1433 - getaddrinfo ENOTFOUND myserverip,mynewport",
        "code": "ESOCKET"
    },
    "name": "ConnectionError"
}

How to solve it?

aminits · Accepted Answer · 2020-10-17 05:40:08Z

1

The mssql docs state that port can be specified with the 'port' key:

var DbConnectionString = {
    user: 'sa',
    password: 'mypassword',
    server: 'serverip',
    port: newport,
    database: 'databasename',
    "options": {
        "encrypt": false,
        "enableArithAbort": true
    },    
};

edited Oct 17, 2020 at 5:40

answered Oct 16, 2020 at 16:24

aminits

1844 bronze badges

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

1 Comment

aminits Over a year ago

I added a small fix (port argument should be an integer). It worked for me.

Collectives™ on Stack Overflow

How to change default port 1433 on SQL Server in a node.js connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related