Change Password in SQL Server Management Studio 2014

In SQL Server Management Studio, we can manage multiple databases, But which application should access which database is defined in the configuration file of the application and this access is based on the credentials of SQL Server Database i.e database name, user and password.

Today, you will learn how to change password of a database user in SQL Server 2014.

So Let’s get started!

Connect with SQL Server Management Studio 2014

sql-server, sql, sql-server-2014

Go to Databases=>Security=>Logins, right-click the “User” to which you need to change the password (User is shown in “Login” section in above fig.) and hit “Properties”

ms-sql-server,

In “General” tab, below login, type your desired password. And then re-type it

sql-server-management-studio, change-password

Click “OK” and you are done. Restart SQL

sql-database,sql-server-management-studio-2014

Now type the new Password and “Connect”

sql-server-2016,multiple-databases,database-password

Be the first to comment

Leave a Reply

Your email address will not be published.


*