Endpoint Protection

Hi,
I need to change the database user password, my database is stored in a SQL 2005 Server.
The username that i want to change is in Admin > Servers > Database Server  -  Database User:

Thanks

You can reset this password from SQL Management studio.

Once you open it --Under sem5 ( or whatevr the name of the databse is ) Login --you will find that user just go to properties of the user and reset it.

This is the closest article i found
http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

like shown in the link do the same for your User account. and SA.

Hi,

you need to reconfigure the server using Management server configuration (MSC)Wizard, you can change the passwor dusing the SQl manager studio. But once changedyou need to run MSC Wizard .

Cheers
Pete

If the password has been forgotten and needs to be reset you can use the Microsoft SQL Server Enterprise Manager.

• On the SQL server go to Start menu - Programs - Microsoft SQL Server - Enterprise Manager
• Expand the SQL Server Group, the correct SQL server (local) and then the Security section.
• Select Logins on the left hand side and then properties for the sem5 user account.
• Type in a new password. Do not do this on a SQL server currently in use by one or several SEPM servers as you would need to reconfigure the SEPM servers using the Management Server Configuration Wizard before being able to connect again.