Thursday, 20 April 2017

Connecting to sql server with tedious - issue with defining the server

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': enter image description here

And the server configuration manager for SQLTEST: enter image description here

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