In this article I will show you how to recover Embedded Database password in SEPM 12.1 X version.
1) Navigate to <Installed drive>:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php
2) Take a backup of php.ini file (very important)
3) By default PHP.INI is a read only file. Right click –uncheck read only- Click Ok
4)Open the PHP.INI file in a notepad
5) Set the following properties to on
display_startup_errors = On
log_errors = On
report_memleaks = On
track_errors = On
As shown in the screen
6) Save the file
7) Navigate to <Installed drive>:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common
8) Take a backup of connectdb.php ( Very important)
9) By default connectdb.php is a read only file. Right click –uncheck read only- Click Ok
10) Open in a notepad
11) Look for this line
ado_connect($conn_id, $ODBCDSN, $dbuser, $dpwd, $ConnectionTimeout, $CommandTimeout, $dbport, $dbserver,$isWinAuth);
Just add echo $dpwd as shown in the screen shot
Save the changes close the file
12) Open the odbc connection on 64 bit machine it will be in C:\Windows\SysWOW64\odbcad32.exe on 32 bit it will be in C:\Windows\System32\odbcad32.exe
13) Click on System DSN, Select Symantec endpoint protection DSN , click Configure
14) We need to break the connection by inserting an incorrect dba password. Under the login tab for password just key in any password (ex KingJulien)
14) Click on test connection, it should now say “connection failed, invalid user id or password”
15) Login to SEPM now, you will find the password in the home tab as show.
Once you are done , replace the backed up PHP.INI and Connectdb.php files in the respective location.
You can find this article as an attachement. Images are little smaller in size , feel free to download and Zoom it..
I hope this was helpful, Please do vote if you like it.. :)
“If you're good at something, never do it for free” – The Joker