For ODBC

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.

How to recover forgotten ODBC DB password for Symantec Endpoint Protection Manager (Simpler & Easier version)

https://www-secure.symantec.com/connect/articles/how-recover-forgotten-odbc-db-password-symantec-endpoint-protection-manager-simpler-easier-

Purpose: 

Recover password for the ODBC DB connection.  The ODBC DB password doesn't change with changing the administrator password for the console login.  A failure in the reporting component displaying "no information" would require reconfiguring the ODBC component and the original password may be long since forgotten.

Procedure:

Before Starting make sure that there is a valid ODBC System DSN created.  You can check by going to Start --> Administrative Tools --> Data Sources (ODBC).  Go to the System DSN tab.  You will see the SymantecEndpointSecurityDSN entry in the combo box.  Click configure, on the default tab (ODBC) you should find the Test Connection button at the bottom.  Click and see if it works.  You would enter your password and username at the Login tab.  The default username should be dba.

Let us now start the recovery process.

1. Go to the Symantec Endpoint Protection Manager base directory.
2. Open the folder Inetpub.
3. Open the folder Reporting.
4. Open the folder Common.
5. Make a copy of the file called connectdb.php; mostly for backup purposes if you feel something broke.
6. Right-click the file connectdb.php, and go to Properties.
7. Uncheck the Read-only box; we want to edit this file.
8. Open the connectdb.php file in notepad or your favorite editor.
9. Go to line 76.  The line should begin with ado_connect(&$conn_id, $ODBCDSN, $dbuser, $dpwd, .....)
10. Right before the line, enter the following code: 
    

    echo "ODBC PASSWORD: ".$dpwd;
    

11. This code echos the value of $dpwd, which is what we want.
12. Now to view it go to the following url:  http://127.0.0.1:8014/reporting
13. 127.0.0.1 can be replaced with the ip address of your SEPM box.
14. Enter in your normal SEPM login.
15. At the top of your page you should see the password.
16. Now let us roll back our changes to the connectdb.php.  Remove the changes or delete the connectdb.php and use your backed-up copy of the connectdb.php file. 
17. Recheck the Read-only box in the file properties.
18. Enter this in your Data Source (ODBC) password box, test the connection

Hi,

You should try first time installation password as a database password. Do you remember that password?

Given steps may work with SEP 11.x but won't work with SEP 12.1.

Total how many clients do you have in the network?

Check this article: https://www-secure.symantec.com/connect/forums/rec...

Don't forget to promote following idea.

https://www-secure.symantec.com/connect/ideas/sepm...