"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server

Q

How To Change the Password of a Login Name in SQL Server?

✍: FYIcenter.com

A

If a developer lost the password of his or her login name, you can reset the password with the "ALTER LOGIN" statement as shown in this tutorial example:

-- Login with sa

ALTER LOGIN FYI_DBA WITH PASSWORD = 'fyicenter';
GO
Command(s) completed successfully.

FYI_DBA's password is changed now. Try it with the SQLCMD tool:

C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U FYI_DBA -P fyicenter
1> QUIT

You can also use the "ALTER LOGIN" to change your own password.

 

Managing Security, Login and User in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-20, 243👍, 0💬