Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

MS SQL Server 2005 Database password need to be changed

Created: 25 Mar 2013 | 3 comments

Hi,

In our organization, We have SEP version 11.0.6 is running. The database is configured on MS SQL 2005 and it is on a remote server.

During configuring SQL server 2005 for SEPM 11.0.6, A weak password has configured and I want to change change it.

How I change it?

Operating Systems:

Comments 3 CommentsJump to latest comment

Brɨan's picture

You can do this on the SQL server. See here:

https://www-secure.symantec.com/connect/forums/how...

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SebastianZ's picture

Simply use the SQL Management studio wizard to access the SQL Server and change the password for SEP user there. Afterwards run the SEPM Server Management configuration Wizard to resynchronize it with the DB.

Mithun Sanghavi's picture

Hello,

Please Try these Steps:

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.

NOTE: There are high chances that the reporting component may break on the SEPM, and you may have to run the Management Server Configuration Wizard...

If that does not work, high chances you may to end up in completely Uninstall of SEPM. 

Please Let the Symantec Connect users know what happens on the same...

Reference: https://www-secure.symantec.com/connect/forums/how-change-database-user-password

https://www-secure.symantec.com/connect/forums/how-can-i-change-sem5-password-stored-sepm

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.