Video Screencast Help

SEPM ODBC Password Lost - How to reset?

Created: 19 May 2012 | 9 comments

I have inherited an Endpoint Protection Manager running SEPM 12.1 RU1.  Recently, the manager quit connecting to the database and I began troubleshooting the issue.  I have since found the ODBC test fails and, unfortunately, I do not have the password for the defaul 'admin' account.  Any suggestions?

Comments 9 CommentsJump to latest comment

pete_4u2002's picture

On the management server computer, click Start > All Programs > Symantec Endpoint Protection Manager > Symantec Endpoint Protection Manager.

In the Logon screen, click Forgot your password?.

In the Forgot Password dialog box, type the user name for the account for which to reset the password.

For domain administrators and limited administrators, type the domain name for the account. If you did not set up domains, leave the domain field blank.

Click Temporary Password.

 

http://www.symantec.com/docs/HOWTO55059

 

Log into the manager as the original "admin" when the password login states that it has expired, change the password to the same password used before.

Then enter into the database. Once into the database the user can go into the ODBC and edit the login information and the connection should be able to connect with out a problem.
 

Ashish-Sharma's picture

HI,

I think problem are solved, we are not received any comment after create thread.

Thanks In Advance

Ashish Sharma

 

 

guru_1's picture

If your issue is still persist try below step

For ODBC

Click Start > Run and type "odbcad32"

Data required in ODBC

Username should be "DBA"
Password should be the first password that you used to login to SEPM.
Server name should be the name of the server.
Database name should be  "sem5"

If you dont remember the password follow the following steps to get the password

  •  Remove all the details from ODBC and change the name for the database from sem5 to SEM
  • Go to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\
  • Go to php.ini properties, and uncheck the read-only option
  • Open php.ini using a notepad
  • Modify the following lines to read:

             display_errors = On
             display_startup_errors = On

Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> ASAProv.90<br/><b>Description:</b> Request to start/stop database denied' in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\ado.php:40 Stack trace: #0 C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\ado.php(40): com->Open('Provider=ASAPro...', 'DBA', 'password') #1 C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\connectdb.php(46): ado_connect(Object(com), 'SymantecEndpoin...', 'DBA', 'password', NULL, NULL) #2 C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Login\curl_funcs.php(360): connectnav(Object(com)) #3 C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Login\curl_funcs.php(98): doProcessLoginResponse('admin', '<?xml version="...', '<?xml version="...', 0) #4 C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Login\Login_verify.php(2 in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\ado.php on line 40

Note: The password next to DBA which is bold in the above example is the password for ODBC

  • Open php.ini using a notepad
  • Again Modify the following lines to read:

             display_errors = Off
             display_startup_errors = Off

  • Go to ODBC and change the name of the database to SEM5
  • Go to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini properties, and check read-only

Then try the ODBC with the password and the connection should be successful.

Regard

RajGuru

Slogan: Delighting The Presence

 

SameerU's picture

Hi

As per my knowledge dba password cannot be recovered

Regards

 

guru_1's picture

Hi Sameer - I have tried and it's working

Regard

RajGuru

Slogan: Delighting The Presence

 

rs_cert's picture

No boss- try the attach link's step then you will get the answer....

guru_1's picture

Hi IBAHawk

Your password recovered or not?

Regard

RajGuru

Slogan: Delighting The Presence