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?
Discussion Filed Under:
Comments 9 Comments • Jump to latest comment
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.
Cheers!
Pete
Help Link: http://www.symantec.com/business/support/overview.jsp?pid=54619
Hi
Reset admin password
http://www.symantec.com/docs/TECH186978
Thanks.
How to find the Database password for Embedded Database
https://www-secure.symantec.com/connect/articles/how-find-database-password-embedded-database
https://www-secure.symantec.com/connect/forums/embedded-database-password
HI,
I think problem are solved, we are not received any comment after create thread.
Thanks In Advance
Ashish Sharma
SEPM Knowledgebase Documents
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
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
display_errors = Off
display_startup_errors = Off
Then try the ODBC with the password and the connection should be successful.
Regard
RajGuru
Slogan: Delighting The Presence
Hi
As per my knowledge dba password cannot be recovered
Regards
Hi Sameer - I have tried and it's working
Regard
RajGuru
Slogan: Delighting The Presence
No boss- try the attach link's step then you will get the answer....
Hi IBAHawk
Your password recovered or not?
Regard
RajGuru
Slogan: Delighting The Presence
Would you like to reply?
Login or Register to post your comment.