Skip to content
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

Trusted Connection = Yes prompts for password #890

Open
sfscgjohnson opened this issue Dec 10, 2021 · 1 comment
Open

Trusted Connection = Yes prompts for password #890

sfscgjohnson opened this issue Dec 10, 2021 · 1 comment
Labels
mssql Microsoft SQL Server driver triage

Comments

@sfscgjohnson
Copy link

Attempting to setup a Connection to MSSQL Server with a Connection String

Provider=SQLNCLI11;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;

This should be integrated security but I am being prompted to enter a password and Tests fail if no password is entered.

@gjsjohnmurray gjsjohnmurray added the mssql Microsoft SQL Server driver label Jul 22, 2022
@fzhem
Copy link

fzhem commented May 13, 2024

Mssql driver uses tedious which does not support integrated security. Also, connection string does not ask for password now.

If you want the integrated security you can try a fork of the official driver which allows you to choose msnodesqlv8 that has integrated security support: https://marketplace.visualstudio.com/items?itemName=fzhem.sqltools-driver-mssql-commver

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
mssql Microsoft SQL Server driver triage
Projects
None yet
Development

No branches or pull requests

3 participants