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.
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?