Endpoint Protection

 View Only

  • 1.  MS SQL Server 2005 Database password need to be changed

    Posted Mar 25, 2013 11:18 AM

    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?

     

     



  • 2.  RE: MS SQL Server 2005 Database password need to be changed

    Posted Mar 25, 2013 11:22 AM

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

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



  • 3.  RE: MS SQL Server 2005 Database password need to be changed

    Posted Mar 25, 2013 11:34 AM

    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.



  • 4.  RE: MS SQL Server 2005 Database password need to be changed

    Trusted Advisor
    Posted Mar 25, 2013 12:38 PM

    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