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

How to find the Database password for Embedded Database

Created: 23 Jul 2009 • Updated: 27 Jul 2009 | 15 comments
Language Translations
Warrior6945's picture
+15 15 Votes
Login to vote

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

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.

Comments 15 CommentsJump to latest comment

kavin's picture

Can you please mention where will I get the error????
And am I supposed to use the normal username and password while logging from the reporting site?

0
Login to vote
Warrior6945's picture

You would get the error if you try to login to the link http://localhost/reporting

And yes you have to use the normal username and password that you use while logging in to SEPM Console.

Hope this answers your question

0
Login to vote
Rafeeq's picture

You will get it when you try to log in to the SEPM cosole or reporting component

You never tried this before

check this if you want step by step one.. even this is snipped from our forum

http://www.homidoit.com/?p=164

Rafeeq

0
Login to vote
Sandeep Cheema's picture

Check this from around a year back........
http://www.symantec.com/connect/forums/how-reset-password-embedded-database

De facto when AV does something, it starts jumping up and down, waving its arms, and shouting...

"Hey!  I found a virus!  Look at me!  I'm soooo goooood!"

0
Login to vote
Rafeeq's picture

Hello Sandeep,

I think even before this , we found it accidently while trouble shooting on reporting component issue.

Cheers

Rafeeq
 

0
Login to vote
Sandeep Cheema's picture

@Rafeeq: Yup....This is the same thing that you and I had discovered back then...back there.....eh.?

De facto when AV does something, it starts jumping up and down, waving its arms, and shouting...

"Hey!  I found a virus!  Look at me!  I'm soooo goooood!"

0
Login to vote
Vikram Kumar-SAV to SEP's picture

 Yup Rafeeq ..I too remember that..I quess u even sent a TOI for tht..

Vikram Kumar

Symantec Consultant

The most helpful part of entire Symantec connect is the Search button..do use it.

0
Login to vote
Mario Udiljak's picture

I don't have any info in the ODBC in the first place. How is that?

And what should I do to get DBA password?

Capture.PNG
0
Login to vote
Ghent's picture

If you're running a 64 bit system, you may have to open the "32 bit version" of ODBC.

0
Login to vote
ThaveshinP's picture

Is there a way to recover the SQL database password if its lost?

0
Login to vote
Ambesh_444's picture

Really nice article,

Good luck for next..

Cheers!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

0
Login to vote
cooldude's picture

It's realy a nice article and help in 11.x version.

Is it work in 12.x?

0
Login to vote