Endpoint Protection

 View Only

How to recover forgotten ODBC DB password for Symantec Endpoint Protection Manager (Simpler & Easier version) 

Oct 07, 2011 11:32 AM

Purpose: 

Recover password for the ODBC DB connection.  The ODBC DB password doesn't change with changing the administrator password for the console login.  A failure in the reporting component displaying "no information" would require reconfiguring the ODBC component and the original password may be long since forgotten.

Procedure:

Before Starting make sure that there is a valid ODBC System DSN created.  You can check by going to Start --> Administrative Tools --> Data Sources (ODBC).  Go to the System DSN tab.  You will see the SymantecEndpointSecurityDSN entry in the combo box.  Click configure, on the default tab (ODBC) you should find the Test Connection button at the bottom.  Click and see if it works.  You would enter your password and username at the Login tab.  The default username should be dba.

Let us now start the recovery process.

  1. Go to the Symantec Endpoint Protection Manager base directory.
  2. Open the folder Inetpub.
  3. Open the folder Reporting.
  4. Open the folder Common.
  5. Make a copy of the file called connectdb.php; mostly for backup purposes if you feel something broke.
  6. Right-click the file connectdb.php, and go to Properties.
  7. Uncheck the Read-only box; we want to edit this file.
  8. Open the connectdb.php file in notepad or your favorite editor.
  9. Go to line 76.  The line should begin with ado_connect(&$conn_id, $ODBCDSN, $dbuser, $dpwd, .....)
  10. Right before the line, enter the following code: 
    echo "ODBC PASSWORD: ".$dpwd;
    
  11. This code echos the value of $dpwd, which is what we want.
  12. Now to view it go to the following url:  http://127.0.0.1:8014/reporting
  13. 127.0.0.1 can be replaced with the ip address of your SEPM box.
  14. Enter in your normal SEPM login.
  15. At the top of your page you should see the password.
  16. Now let us roll back our changes to the connectdb.php.  Remove the changes or delete the connectdb.php and use your backed-up copy of the connectdb.php file. 
  17. Recheck the Read-only box in the file properties.
  18. Enter this in your Data Source (ODBC) password box, test the connection.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

May 10, 2012 03:31 AM

Good one !!

Nov 29, 2011 05:39 PM

Thumbs up for this.

Nov 28, 2011 01:58 PM

This is a great how-to, and it let me get my password from an install that was set up before my time.

Thanks so much!

Related Entries and Links

No Related Resource entered.