"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, 363👍, 0💬

General MySQL Oracle SQL Server