This issue has been solved.

How to change database user password

Created: 16 Jul 2009 • Updated: 21 May 2010
iug's picture
Login to vote
+2 2 Votes

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

Quick Look Solution

SQL Studio

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.

Filed Under

Comments

Vikram Kumar-SAV to SEP's picture
Vikram Kumar-SAV to SEP
Symantec Employee
Accredited
16
Jul
2009
SOLUTION

SQL Studio

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.

pete_4u2002's picture
pete_4u2002
Symantec Employee
Accredited
16
Jul
2009

Hi, you need to reconfigure

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
Mithun Sanghavi
Symantec Employee
Accredited
06
Aug
2009

Probable Fix

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.