-
Notifications
You must be signed in to change notification settings - Fork 7
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Is it possible to use it with msnodesqlv8 and Windows Authentication? (Trusted Connection) #56
Comments
There is currently no plans in place to implement the use of the 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. |
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: { 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 connectionString = "server=.;Database=Master;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}"; sql.query(connectionString, query, (err, rows) => { const sql = require("msnodesqlv8"); const connectionString = "server=.;Database=Master;User=developmentID;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}"; sql.query(connectionString, query, (err, rows) => { Software versions NodeJS: Node 18.15.0 node-mssql:msnodesqlv8 SQL Server:SQL Server 2019 |
Any idea we have Kerberos as authentication scheme that can be used? |
@bommulurianji2 |
How can i use Windows Authentication. (Trusted Connection)?
The text was updated successfully, but these errors were encountered: