Unable to crate a Kerberos connection : How to mention the Authentication Scheme to use Kerberos and development account identity in the connection object. #1491
The Node.js application should connect to the MS SQL server on a internal environment with the development account using the Kerberos authentication scheme.
Actual behavior:
The Node.js application is not connecting to the MS SQL server on internal environment with the development account using the Kerberos authentication scheme.
I don't find a way to mention the scheme and the relevant drivers..
for example : authPlugins: {
authentication_kerberos_client: plugins.authentication_kerberos_client()
Configuration:
currently using something like this which is working in terms of connection, But when we add the development id not working..
const connectionString = "server=.;Database=Master;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}";
const query = "SELECT name FROM sys.databases";
const connectionString = "server=.;Database=Master;User=developmentID;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}";
const query = "SELECT name FROM sys.databases";
Expected behavior:
The Node.js application should connect to the MS SQL server on a internal environment with the development account using the Kerberos authentication scheme.
Actual behavior:
The Node.js application is not connecting to the MS SQL server on internal environment with the development account using the Kerberos authentication scheme.
I don't find a way to mention the scheme and the relevant drivers..
for example : authPlugins: { authentication_kerberos_client: plugins.authentication_kerberos_client()
Configuration:
currently using something like this which is working in terms of connection, But when we add the development id not working..
----working sample ------ const sql = require("msnodesqlv8");
const connectionString = "server=.;Database=Master;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}"; const query = "SELECT name FROM sys.databases";
sql.query(connectionString, query, (err, rows) => { console.log(rows); }); ----Not working sample ------
const sql = require("msnodesqlv8");
const connectionString = "server=.;Database=Master;User=developmentID;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}"; const query = "SELECT name FROM sys.databases";
sql.query(connectionString, query, (err, rows) => { console.log(rows); })
Software versions