Node-mssql: Cannot connect to local DB with instance name

[linvi]

Hello,

First of all, thank you for this library it looks good and is very simple to use.

I am encountering an issue when using the tedious driver with named instances.
Here is my configuration :

var config = {
    user: 'sa',
    password: 'mypassword',
    server: 'localhost\\SQLSERVER_2014',
    database: 'TestDB',
    options: {
        encrypt: false
    }
}; 

With the same configuration, I am able to connect with msnodesqlv8.
Is it better to use tedious, if yes why? Is there anything wrong with the configuration?

Find the attached error with the tedious driver :

{ [ConnectionError: Failed to connect to localhost:undefined in 15000ms]
  name: 'ConnectionError',
  message: 'Failed to connect to localhost:undefined in 15000ms',
  code: 'ETIMEOUT' }

I tried to look at the code myself but I am not familiar enough with it for now to find where the error could be located.

Thanks

[jcmilhot]

Hello,

I was facing the same issue, and finally I've found the solution :

try this :

• First, Start the "SQL SERVER BROWSER" Service in Windows services (I've configured it to start automatically)
• Second, allow SQL Server Express to accept remote connections over TCP/IP for port 1433 : http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx

Finally restart 'SQL Server' and 'SQL Browser Agent' services

[patriksimek]

Closing due to inactivity.

[oliviermutombo]

That helped!