fzhem
commented
3 months ago 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
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.