script - sql server password changer
How do I script a password change for a SQL server login? (3)
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.
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'
How to change the password of 'sa' using sql queries?
Try this one :
GO ALTER LOGIN [LOGIN_NAME] WITH DEFAULT_DATABASE=[master] GO USE [master] GO ALTER LOGIN [LOGIN_NAME] WITH PASSWORD=N’NewPassword’ MUST_CHANGE GO