mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.44k stars 291 forks source link

Add option "use windows authentication" in connection Assistant for SQL Server #843

Open emerxom opened 2 years ago

emerxom commented 2 years ago

that's it

philcart commented 2 years ago

Definitely need this as an option. We have a couple of servers where SQL Authentication is disabled.

MichaelEidsonEER commented 1 year ago

Was this feature ever added or have you guys discovered a workaround? I sure could use it as well. Thanks!

fzhem commented 1 month ago

Currently, the mssql driver uses tedious which does not support windows authentication. However, msnodesqlv8 driver has support for this.

I have created a fork of the mssql extension that allows you to choose between tedious or msnodesqlv8: https://marketplace.visualstudio.com/items?itemName=fzhem.sqltools-driver-mssql-commver