Connect to SQL Server with mssql for node.js

Question

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/IP 127.0.0.1
    database: 'ACCOUNTDB'
};

Patrik Simek · Accepted Answer · 2014-01-25 04:00:29Z

19

You should be able to connect to named instance when using tedious driver with this config:

var config = {
    user: '...',
    password: '...',
    server: '192.168.1.101',
    driver: 'tedious',
    database: 'ACCOUNTDB',
    options: {
        instanceName: 'sql'
    }
};

Documentation also says:

The SQL Server Browser service must be running on the database server, and UDP port 1444 on the database server must be reachable.

Config for msnodesql driver is little more complicated because it's connection string doesn't support named instances by default (should change in future):

var config = {
    user: '...',
    password: '...',
    server: '192.168.1.101',
    driver: 'msnodesql',
    database: 'ACCOUNTDB',
    connectionString: "Driver={SQL Server Native Client 11.0};Server=#{server}\\sql;Database=#{database};Uid=#{user};Pwd=#{password};"
};

answered Jan 25, 2014 at 4:00

Patrik Simek

1,04810 silver badges14 bronze badges

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

1 Comment

edhubbell Over a year ago

In my experience, I needed to use 'userName' (case sensitive) and not 'user'.

Cassius Horvath · Accepted Answer · 2018-09-13 09:58:04Z

Ok, I had the same issue, will try to help. this is my config exemple

const config = {
    user: 'sa',
    password: '****',
    server: 'DESKTOP-Q5TO47P',
    database: 'dbname',
    options: {           
        encrypt: false
    }
};

You need to turn on the SQL Server Browser. Go to start up menu or the search and look for SQL Server Configuration Manager. Run it! (Im using 2018 version)

In the left Tab click on SQL Server Services
now in the right tab double click on SQL Server Browser
will open a window, you will see 3 tabs, go for the Service tab
change start mode to Automatic and apply
left click on SQL Server Browser and click restart
Back to the right tab click on SQL Server Network Configuration
then Client Protocols
change TCP/IP to enable

user1781272 · Accepted Answer · 2014-12-11 22:51:55Z

1

Something that caught me is the fact that port and instanceName are mutually exclusive. Meaning that you only need one or the other.

answered Dec 11, 2014 at 22:51

user1781272

9622 gold badges14 silver badges25 bronze badges

1 Comment

EWit Over a year ago

This would be better suited as a comment instead of an answer.

Soham Biswas · Accepted Answer · 2021-06-15 15:57:59Z

0

I recently encountered this problem, I was trying to connect the MSSQL that is hosted on a remote server. The config that I had to use is-

let config = {
    user: 'user',
    password: 'password',
    server: 'server',
    database: 'database',
    "options":{
        instanceName: 'instanceName',
        "encrypt":true,
        "enableArithAbort":true,
        "trustServerCertificate": true,
       }
};
module.exports=config;

For getting the instance name use SELECT @@servicename in SSMS

edited Jun 15, 2021 at 15:57

answered Jun 15, 2021 at 15:43

Soham Biswas

316 bronze badges

Collectives™ on Stack Overflow

Connect to SQL Server with mssql for node.js

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related