[Feature Request]: Support for Blank Password in MSSQL Extension

[adc-vjoshi]

Feature Description

I have a database with a read-only login that uses no password (the password is empty). However, the MSSQL extension currently requires a password field to be filled in, making it impossible to connect with this account.
Could a feature be added to allow connections with a blank password?
If this is already possible and I’m missing an alternative way to do this, please let me know. Thank you!

Problem and Motivation

Unable to connect to db with no password login

Related Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query results panel
• Query editor
• Object Explorer
• Table Designer
• Schema Compare
• Schema Designer
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• GitHub Copilot integration
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the area

No response

Confirmation

• I have searched existing feature requests and couldn't find a match
• I want to help implement this feature

[Benjin]

You should be able to connect by setting these values for the connection in your config JSON:

"user": "yourUsername",
"password": "",
"emptyPasswordInput": true,

Does that work for you?

[adc-vjoshi]

It doesn't work. I tried changing settings.json in ~/Library/Application Support/Code/User/ but it didn't take effect. Is there a different config json?

The password is a required field so I am not able to bypass it in the UI (please see attached screenshot)

FYI, I am using a Macbook.