vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

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

Open emerxom opened this issue 4 years ago • 7 comments

that's it

emerxom avatar Jul 16 '21 17:07 emerxom

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

philcart avatar Sep 19 '21 23:09 philcart

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

MichaelEidsonEER avatar Mar 24 '23 14:03 MichaelEidsonEER

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

fzhem avatar May 13 '24 22:05 fzhem