Hi- If you forgot the password then easy way to find it
https://www-secure.symantec.com/connect/forums/sep12-lost-password-embedded-database
How to find the Database password for Embedded Database
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.