Here we are assuming that we have hoststud user and we need to change the password of hoststud user with below steps:
- First login to MS SQL management studio with current password.
- Now click on “Security >> Logins >> hoststud (user)” under “Object Explorer”.
- After that right click on user hoststud and click on “Properties”.
- A new window will appear where you can enter password of your database and click on “OK” button.