Auth0 / tedious unable to connect to a public SQL Server

340 views Asked by At

I'm using Auth0 with a custom database, when adding a Sql Server script (that uses tedious) when a user gets created I receive following error message:

[Error] Failed to get response from SQL Server Browser on 'serverIp'

Connection object:

var connection = sqlserver.connect({
    userName:  'userName',
    password:  'passWord',
    server:    'serverIp',
    /* port parameter is not needed because 1433 is used as default */
    options:  {
        database: 'databaseName',
        instanceName: 'sqlexpress' /* when removing this the error becomes: timeout : failed to connect to 'serverIp' in 15000ms */
    }
});

The serverIp is the IPv4 Address retrieved by using the ipconfig command. I enabled TCP/IP and the SQL Server Browser, my firewall is also temporarily disabled for testing purposes and the IPAll has TCP Port 1433.

enter image description here

enter image description here

It is possible for me to open the SQL Server on another computer so how does it happen that Auth0 / tedious does not allow a connection?

0

There are 0 answers