Just what the title says, I need to change the password for an existing sql server login and I want to do it via sql script.
Change Password NOTE: A DBA or somebody with sufficient privilege can change the existing password of a user and create a new user. Database to which the user is permitted to be work. User id of the user whose password you are changing.
Click on Security and make sure that SQL Server and Windows Authentication mode is selected. Then click OK. In the Object Explorer expand Security>Logins and then right click on the user to change the password. Change the password and confirm the change.
If the user already has the ALTER ANY LOGIN permission (i.e. the user can change any password for any user) then this works:
alter login mylogin with password = 'mylogin'
Otherwise, if you don't want to make every user in your system a superuser, add a parameter of the old password for the same command:
alter login mylogin with password = 'mylogin' old_password='oldpassword'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With