How to use mssql connection using ip/instance?

Question

I'm trying to connect to a production SQL Server instance but it fails to connect.

Could anyone help?

I'm grateful for the community's attention.

.env:

MSSQL_SERVER=ip/instance
MSSQL_PORT=1433
MSSQL_USER=sa
MSSQL_PASSWORD=password
MSSQL_DB_NAME=database

Error:

Failed to connect to ip/instance:1433 - getaddrinfo
ENOTFOUND ip/instance

adonisjs@lucid

mssql: {
      client: "mssql",
      connection: {
        user: Env.get("MSSQL_USER"),
        port: parseInt(Env.get("MSSQL_PORT")),
        server: Env.get("MSSQL_SERVER"),
        password: Env.get("MSSQL_PASSWORD", ""),
        database: Env.get("MSSQL_DB_NAME")
      },
      healthCheck: false,
      debug: false,
    },

Code:

Database.connection('mssql').from('dbo.EMP').select('*')

can you post code where you actually connect to the DB using these libraries? — Joe, Dec 21 '21 at 01:02
Did you try using a \ instead of a / (per https://github.com/tediousjs/tedious/issues/1364) for example "1.2.3.4\instanceName" — Joe, Dec 21 '21 at 01:23
message": "Failed to connect to ip:undefined - self signed certificate", — marcelo.delta, Dec 21 '21 at 01:31
Thank you. Its work with - options: { encrypt: false, // for azure trustServerCertificate: true, // change to true for local dev / self-signed certs }, — marcelo.delta, Dec 21 '21 at 03:15

score 0 · Accepted Answer · answered Jan 05 '22 at 00:27

0

Thank you. Its work with -

options: { encrypt: false, // for azure trustServerCertificate: true, // change to true for local dev / self-signed certs

answered Jan 05 '22 at 00:27

marcelo.delta

2,730
5
36
71

How to use mssql connection using ip/instance?

1 Answers1