Video Screencast Help

How to change database user password

Created: 16 Jul 2009 • Updated: 21 May 2010 | 3 comments
iug's picture
This issue has been solved. See solution.

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

Comments 3 CommentsJump to latest comment

Vikram Kumar-SAV to SEP's picture

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.

Vikram Kumar

Symantec Consultant

The most helpful part of entire Symantec connect is the Search button..do use it.

SOLUTION
pete_4u2002's picture

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

Mithun Sanghavi's picture

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.

 

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.