I am trying to connect to SQL Server on my local machine. I am trying to use tedious and tedious-ntlm. The configuration for both is as below:
var tds = require("tedious-ntlm");
//var tds = require("tedious");
var config = {
userName: 'pratikdb',
password: 'pratikdb',
server: '.',
options: {
database: "TEST",
debug: {
packet: false,
payload: false,
token: false,
data: false
},
encrypt: true
}
};
http.createServer(app).listen(app.get('port'), function () {
console.log('Express server listening on port ' + app.get('port'));
var connection = new tds.Connection(config);
connection.on('connect', function (err) {
console.log(err);
});
});
When I am working with tedious, I am getting this error:
ConnectionError: Failed to connect to .:1433 - getaddrinfo ENOTFOUND . .:1433]
message: 'Failed to connect to .:1433 - getaddrinfo ENOTFOUND . .:1433', code: 'ESOCKET'
When I am working with "tedious-ntlm", I am getting this error:
Connection to .:1433 - failed Error: getaddrinfo ENOTFOUND . .:1433
As mentioned here, I tried using ip of machine even then I am getting same error.
Edit:
When I modified the config as below as per suggestion by @jmugz3:
var config = {
userName: 'pratikdb',
password: 'pratikdb',
server: 'DELL',
options: {
instanceName: ".",
database: "TEST",
debug: {
packet: false,
payload: false,
token: false,
data: false
},
encrypt: true
}
};
I am getting error :
Error: Port for . not found in ServerName;DELL;InstanceName;MSSQLSERVER;IsClustered;No;Version;11.0.2100.60;tcp;1433;np;\DELL\pipe\sql\query;;
Can anyone please help me?
Thanks in advance.
Found an answer tedious discussion. Changed my configuration variable to
the main points were to look for were uppercasing of server and instanceName. for some reason tedious is maintaining case-sensitivity in both key and value of array.