Login failed for user ...

[daut]

When I try to connect to remote DB instance using tedious I get an error Login failed for user 'DOMAIN\Username', but when I try using the same credentials with sqlcmd command line tool I can successfully connect.

Does anyone know what could be the difference between sqlcmd and tedious connection allowing one to succeed while breaking the other?

Below is the js code and shell command I use to get this kind of behavior.

import { Connection } from "tedious";

const config = {
  server: "server_name",
  authentication: {
    type: "default",
    options: {
      userName: "DOMAIN\\Username",
      password: "password",
    },
  },
  options: {
    encrypt: true,
    trustServerCertificate: true,
    database: "db_name",
    instanceName: "named_instance",
  },
};

const connection = new Connection(config);

connection.on("connect", function (err) {
  if (err) {
    console.log(err);
  } else {
    console.log("Connected");
  }
});

connection.on("debug", function (text) {
  console.log(text);
});

connection.connect();

sqlcmd -S server_name\\named_instance -U DOMAIN\\Username -P password -d db_name