Video Screencast Help

Embedded Database Password

Created: 07 Jul 2012 • Updated: 10 Jul 2012 | 5 comments
This issue has been solved. See solution.

Hello,

I have only the Password of Server Console Admin.

I want to confirm the DB password for ODBC connectivty

Is there any way to recover it.

Symantec - 11.0.7

DB- Embedded

any other inromation require?

Comments 5 CommentsJump to latest comment

honey_jack's picture

 

How to find the Database password for Embedded Database

https://www-secure.symantec.com/connect/articles/how-find-database-password-embedded-database

Thanks & Regard

Honey Jack

 

If your issue has been solved, please use the "Mark as Solution" for the valid thread.

SOLUTION
honey_jack's picture

Some other link for your refference

https://www-secure.symantec.com/connect/forums/how-reset-password-embedded-database

https://www-secure.symantec.com/connect/forums/lost-database-password

Thanks & Regard

Honey Jack

 

If your issue has been solved, please use the "Mark as Solution" for the valid thread.

sunnyc_up's picture

1. Login to the SEPM where you need to recover the password.

2. It is not necessary to stop any services, and to be best of my knowledge these procedures do no interrupt communication between the manager and clients.

3. Start -> Run: odbcad32

   a. Click the System DSN tab

   b. Select the SymantecEndpointSecurityDSN and then click the Configure button

      i. Click the Database tab

      ii. In the Database File field it should llike this:
      C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5

      iii. Change the “sem5” at the very end to “SEM”

   c. Click OK to exit from the ODBC configuration program

4. Make a backup copy of C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini

5. Right-click on the C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini file and select Properties

   a. Uncheck read-only

6. In notepad open C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini

   a. Modify the following lines to read:
   display_errors = On
   display_startup_errors = On

7. Save and close php.ini

8. Make a backup copy of C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\connectdb.php

9. Right-click on C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\connectdb.php and select Properties

   a. Uncheck read-only

10. In notepad open C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Common\connectdb.php

   a. Search for the word “catch”. It will be in several places, but only two of those places will look like this:

   } catch (Exception $e) {
   $dpwd = "";
   throw $e;
   }

   b. In both places where you found the above add one additional line so that it looks like this:

   } catch (Exception $e) {
   echo "GOT IT - this is your password for database !!! {$dpwd}";
   $dpwd = "";
   throw $e;
   }

11. Save and close connectdb.php

12. In Internet Explorer go to http://localhost:8014/reporting
Note modify your port number in the URL as appropriate.

   a. Login using your SEPM administrator credentials

   b. After a few seconds an error message (dump) will be displayed. Look for “GOT IT” and your password will be displayed at the end of that line.

13. The last step is to undo all the changes you made. Be sure to set both files back to read-only. Also change the name of the database used by the ODBC DSN.

Regard

Sunny Chauhan

vipinart's picture

Hello,

Your attach link is helpful to me. Thanks :)

Is it helpful in SQL DB also?

pete_4u2002's picture

you can chane the sem5 db in sql using sql mgmt studio by logging into windows authentication