Azuredatastudio: Unable to change Account Password

[spartan27244]

• Azure Data Studio Version:

Steps to Reproduce:

1. Changed Azure AD Password
2. Unable to connect to Azure SQL database because it does not prompt for new password
3. Cannot Add a new Account

So I have no way to use this product anymore until I can get it to recognize a new password is needed.

[adsbot[bot]]

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

• Password is not persisted in some cases (#3220)
• Windows authentication doesn't refresh after password change (#2337)
• Connecting from Azure attempts to connect without password (#5808)
  

[aaomidi]

What operating system are you using?

[spartan27244]

Windows Server 2016

Sent from my Samsung Galaxy smartphone.

-------- Original message --------
From: Amir Omidi [e-mail]
Date: 6/30/20 8:42 PM (GMT-05:00)
To: microsoft/azuredatastudio [e-mail]
Cc: Lee Taylor [e-mail], Author [e-mail]
Subject: Re: [microsoft/azuredatastudio] Unable to change Account Password (#11098)

What operating system are you using?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/11098#issuecomment-652120590, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AKZSNDOHP4DR4DMP2TKMUKLRZKA7VANCNFSM4OIPEW5A.

[kburtram]

@spartan27244 have you tried removing and re-adding the account in the Account Manager dialog as a workaround for this bug?

[spartan27244]

There is no account management option in the app.

[aaomidi]

If you login with the new & correct password, it should just accept it and work fine.

If that's not working, open Credential Manager on windows. Go to Windows Credentials. Delete entries that start with Microsoft.SqlTools. This will delete your credentials associated with ADS.

We are in the process of revamping how we do credential storing so we don't have to go through this awkward UI to get credentials removed when an issue happens.

[spartan27244]

It does not ask me to login, login to what?

[aaomidi]

@spartan27244 What I meant was pressing "New Connection" and then entering the server details, username, and password (Assuming you're using SqlLogin) and pressing connect. That should overwrite whatever is currently stored.

[spartan27244]

I have tried deleting the connection and re-adding it. It remembers the account information and does not give me the opportunity to log in or change a password. It simply tri3es to connect and errors out.

[aaomidi]

Alright let's try to do the credential manager route then :)

[spartan27244]

And that would be?

[aaomidi]

https://github.com/microsoft/azuredatastudio/issues/11098#issuecomment-653178559

If that's not working, open Credential Manager on windows. Go to Windows Credentials. Delete entries that start with Microsoft.SqlTools. This will delete your credentials associated with ADS.

[spartan27244]

There is nothing in credential manager that even resembles that entry

[aaomidi]

So you don't have any entries that resemble:

?

If that's the case whats the error you get when connecting to a server?

[spartan27244]

Not a single one

[spartan27244]

[spartan27244]

[aaomidi]

Thanks!

Can you press the +
here, and add your account again?

You can also press Help -> Toggle Developer Tools to get more context on what the error is when failing to refresh your account.

[spartan27244]

I see where you are pointing to and I see my credential there, I deleted it, and upon a reconnect attempt it now goes to a browser to get credential information. i.e. it works. Seems a lot to go through if you had a lot of connections and just needed to update your password.

Thanks.

[aaomidi]

Thanks! I mainly misunderstood your problem as being that you changed your SqlLogin password initially. Sorry about that!