I'm trying to connect to my sql server with a node.js tedious script.
Here's the code of the script I am trying:
var connection = sqlserver.connect({
server: '10.255.127.174\\SQLTEST',
options: {
port: 1433,
database: 'najava',
rowCollectionOnRequestCompletion: true
}
This results in the following error:
connection to 10.255.127.174\SQLTEST:1433 - failed Error: getaddrinfo ENOTFOUND 10.255.127.174\SQLTEST 10.255.127.174\SQLTEST:1433
Here is a picture of my sql server and the output for exec xp_cmdshell 'ipconfig'
:
And the server configuration manager for SQLTEST:
Setting the server to ACTKPTP115\\SQLTEST produces the same result.
I made sure to allow all ports access for udp and tcp in the firewall.
Its sql server 2012 so the it should be compatible with Tedious.
This is a similar issue asked in another thread but none of the solutions worked for me.
Please advise me on how to find out what I should define under server to get it to connect.
via ire
No comments:
Post a Comment