azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Constant prompts to access keychain

Open davemateer opened this issue 2 years ago • 5 comments

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.

davemateer avatar May 03 '22 13:05 davemateer

Duplicate of this in the STS repo : https://github.com/microsoft/azuredatastudio/issues/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?

Charles-Gagnon avatar May 03 '22 18:05 Charles-Gagnon

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.

cssuh avatar May 06 '22 20:05 cssuh

Any news on this ?

cawGitHub avatar Aug 31 '22 06:08 cawGitHub

Did the Visual Studio Code folks find a solution that Azure Data Studio can use? https://github.com/microsoft/vscode/issues/108342#issuecomment-706809960

jwatkin avatar Sep 02 '22 11:09 jwatkin

Any news about how to fix it?

ottopic avatar Sep 12 '22 08:09 ottopic

Any workarounds for this issue?

kamalsivalingam avatar Oct 31 '22 19:10 kamalsivalingam

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

josh-rathke avatar Nov 02 '22 19:11 josh-rathke

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)

stuartpa avatar Feb 26 '23 08:02 stuartpa

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.

cheenamalhotra avatar Mar 29 '23 07:03 cheenamalhotra

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

trangius avatar Oct 05 '23 09:10 trangius