Constant prompts to access keychain

[davemateer]

Azure Data Studio is constantly prompting to access the keychain whenever connecting to a database. The prompt is:

MicrosoftSqlToolsCredentials wants to use your confidential information stored in "M" in your keychain.

(The letter "M" might be something else ... it seems to vary.)

Even after selecting "Always Allow", I will get the prompt again, sometimes during the same day but certainly the next day. It seems to be often losing access whenever the application is closed, although this isn't 100% repeatable.

No other applications on my laptop (MacBook Pro) are doing this.

[Charles-Gagnon]

Duplicate of this in the STS repo : #22385

@abist @kburtram Is this something we're going to investigate? Do you want to keep an issue open here for tracking or just close it and use the STS one?

[cssuh]

I can take a look at this, I'll keep this one open because I'd like to use the ADS milestones to track this issue.

[cawGitHub]

Any news on this ?

[jwatkin]

Did the Visual Studio Code folks find a solution that Azure Data Studio can use?
microsoft/vscode#108342 (comment)

[ottopic]

Any news about how to fix it?

[kamalsivalingam]

Any workarounds for this issue?

[josh-rathke]

I also have this issue. Would be interested in any fixes

[stuartpa]

One issue I've noticed (linked to the the credential being named 'M'), is SqlToolsService is writing the credential name using UTF16 characters (for the M is the first character of the credential name, which starts with the word M i c r o s o f t). (It is also doing the same with the secret, which makes it impossible to display and update the secret using the Keychain UI)

[cheenamalhotra]

The encoding problem has been fixed, however the issue with repeated prompts is another issue related with how keytar module works with multiple processes, and something to fix at Shell level.

[trangius]

I am also affected by this issue. Seems to be no workaround?