[Bug]: saved password erased after 1 failed connection

[burtonrodman]

Description

in a recent update, saved credentials are erased after a single failed connection.
also when prompted for a password, if I go to another window to get the password and come back, the prompt has been dismissed and won't come back when I click "connect" again.

this has significantly reduced the usability.

Steps to Reproduce

1. configure Aspire project to create a SQL database in a container with a fixed password and port
2. start Aspire project, connect to database (127.0.0.1, with manually configured password)
3. connection is successful
4. stop container
5. later, without starting the project, try to connection (forgetting that container is not running)
6. connection fails (as expected)
7. start Aspire Host / sql conatiner
8. try to connect to db
9. password has been erased

Affected Area

• Connection dialog
• Query editor
• IntelliSense/auto-completion
• Query results panel
• Object Explorer
• Table Designer
• Schema Compare
• Schema Designer
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

Version: 1.100.2 (user setup)
Commit: 848b80aeb52026648a8ff9f7c45a9b0a80641e2e
Date: 2025-05-14T21:47:40.416Z (1 wk ago)
Electron: 34.5.1
ElectronBuildId: 11369351
Chromium: 132.0.6834.210
Node.js: 20.19.0
V8: 13.2.152.41-electron.0
OS: Windows_NT x64 10.0.26100

Extension: ms-mssql.mssql, 1.32.0

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue

[Benjin]

Thanks for filing this bug, @burtonrodman. I haven't yet been able to repro this locally. Can you clarify steps 5 and 6 in your repro a little more?

• have you restarted VS Code since the stopping the container and disconnecting?
• what error messages/popups are you seeing when this connection fails?

[burtonrodman]

i'm trying to put together a repro that I can share.

I tried to start a SQL container with docker compose and it did not behave the same.

Will try to do a repro in a fresh Aspire project asap.