azuredatastudio
azuredatastudio copied to clipboard
Feature: Change password of expired login
- SQL Operations Studio Version: 0.25.4
As a Linux user I have a SQL login with assigned password. After the password expires I am unable to reset it via SQL Operations Studio. Any attempts to connect via sqlops or sqlcmd fail with error message that the password for the login expired.
Steps to Reproduce:
- Create a SQL login whose password has to be changed
CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON GO
- Login at SQL Operations studio
It would be extremely helpful to have a dialogue pop up to prompt the user for the new password. This is what SSMS does by default.
So it happens to me on Azure Data Studio. Should this issue continue here or should it be opened anew?
yes, i have same issue while expired my password, so i'm unable to change ads itself
Another customer using only macOS reported this issue, we may want to consider triaging this one.
Same issue.
I've come across this as well, is there a way to know if anyone is looking at doing this, or if there is a workaround that isn't tell my DBA/SRE to turn off MUST_CHANGE when they create a new login?
We have a team upgrading MacBooks to Apple Silicon. I'm the first to upgrade and cannot use VMWare Fusion anymore (not supported on Apple Silicon). I've been using Azure Data Studio instead of SSMS just fine, until --> Login failed for user 'jcarr'. Reason: The password of the account has expired. The only way I can update my password is to log into SSMS on my older MacBook Pro, running VMWare Fusion.
This is not just on MacOS. I have had the same issue on PC running Windows 10 Enterprise 64bit. OS Build 19042.1706
As the original poster reports, there is no dialogue pop up to change password.
Same issue on Ubuntu.