`sqlcmd open ads` fails with: Not enough memory resources are available to process this command"

[stuartpa]

A Bug Bash tester hit this error when opening ADS, even though there is 10GB free on the machine

It might be this issue with too many credentials in credman:

https://github.com/desktop/desktop/issues/15217

[SQLDBAWithABeard]

I fixed this by removing credentials using the CredentialManager module

 $a = Get-StoredCredential  -AsCredentialObject
 $a | Where UserName -Like '*Ben*' | ForEach-Object { Remove-StoredCredential -Target $_.TargetName}

Then I was able to open ADS

[shueybubbles]

Is Azure Data Studio "leaking" credentials? Ie if you create a new connection in ADS and it adds the credential, when you delete the connection does it delete the credential?

[shueybubbles]

Indeed...https://github.com/microsoft/azuredatastudio/issues/21936

[cheenamalhotra]

Credential limit is applicable even when you do delete credentials but needed to save more than a certain number of passwords in Credential Store.. This is also reproducible with CredentialManager PS module (see https://github.com/microsoft/azuredatastudio/issues/20990#issuecomment-1293041067 for more info).

[shueybubbles]

For v1 - detect the error and give a better message.

[stuartpa]

Fixed (better error message added) in #240