Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

how to find

Created: 14 Oct 2012 • Updated: 17 Oct 2012 | 6 comments
This issue has been solved. See solution.

For knowledge purpose I want to know how to find the password of Symantec embedded Data base.

Version - 11.0.6005

Regard

Ashok

Comments 6 CommentsJump to latest comment

rs_cert's picture

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

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.

Jackie007's picture

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.

Thanks....

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you

guru_1's picture

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...

Regard

RajGuru

Slogan: Delighting The Presence

 

akgs's picture

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

akgs's picture

thanks all for your valuable comments