Is it possible to use it with msnodesqlv8 and Windows Authentication? (Trusted Connection)

[ITSNOTSTUPIDIFITWORKS]

How can i use Windows Authentication. (Trusted Connection)?

[JLuboff]

There is currently no plans in place to implement the use of the msnodesqlv8 driver. Looking at the mssql docs on msnodesqlv8 driver, it looks like it would require a decent rewrite or a separate class to implement as all imports will need to be changed.

We are open to contributions if you'd like to work this out. I am no longer working with MS SQL so any new features may not be implemented or at least not in a timely fashion from myself. I will still be doing my best to keep packages up to date which do not introduce breaking changes.

[bommulurianji2]

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

NodeJS: Node 18.15.0

node-mssql:msnodesqlv8

SQL Server:SQL Server 2019

[bommulurianji2]

Any idea we have Kerberos as authentication scheme that can be used?

[JLuboff]

@bommulurianji2 Are you having this issue in this package, connect-mssql-v2 or are you trying to use mssql package? The references above seems to be to mssql and not to this package connect-mssql-v2. The connect-mssql-v2 package is specifically for managing sessions via express-session