Hope the attach step help you

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

• Open IE and brose to  http://localhost:8014/reporting  and login using SEPM credentials.
• It will give an error similar to the following:

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.

You need to retreive that

To recover embedded Database Password on Endpoint Protection

1. Go to Control Panel- Administrative Tools - Data Sources(ODBC) - System DSN tab

2. Choose the Symantec Endpoint Security DSN, click Configure

3. Go to the database tab, under the database name put any value other than "sem5" (such as "sem"), then click OK twice

4. Change the c:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini properties, untick the read-only

5. Open c:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\php.ini" with notepad

6. Set the "display_errors = on" and "display_startup_errors =  on", save the changes and close the file

7. Open internet browser, go to http://localhost/reporting (include port number after localhost if it's not on 80 e.g. http://localhost:8080/reporting/)

8. Try to login using the Endpoint Protection Manager console credential

9. The database password will be displayed next to 'DBA' string on the browser.

10.Do not forget to set the database name back to "sem5" in step 3 and set the "display_errors = off" and "display_startup_errors =  off" in step 6.

Try the attach Step

1) Go to ODBC, enter the user name and password as blah blah.

2) In the database server name, enter the server name as blah.

3) Goto %programfiles%\symantec\symantec endpoint protection manager\php

4) Change the attributes for php.ini to remove the read only.

5) Open the php.ini file and search for "off", make this to be "on" , for all the errorlog and give the path for error_log = syslog to say c:\test\test.txt but not the root of any drive like c:\test.txt as this will not generate a log, I dont know but this could be a bug with php.

6) Login to SEPM and you should get, "unable to communicate with reporting component"

7) The log file generated will have your username as DBA and the good working password set in originally.

*Edited : Dont forget to make php.ini back to read only once done with the editing.

How to reset password on embedded database

http://www.symantec.com/business/support/index?pag...

Thanks to all for your reverts. I will try and get back you if any concern.