Video Screencast Help

SEPM should store DBA password in cache or should have access to reset DBA password like admin (Embedded database)

Created: 11 Aug 2011 • Updated: 19 Jun 2012 | 12 comments
Chetan Savade's picture
7 Agree
1 Disagree
+6 8 Votes
Login to vote

Hi,

When we do repair of SEPM or run the management server configuratin wizard it will prompt to enter DBA password

Many users don't remember the password or when administrator leaves the company he doesn't share it. In many cases troubleshooting stops due to DBA password unavailibility.

SEPM should store DBA password in cache or should have access to reset DBA password like admin

 

Comments 12 CommentsJump to latest comment

c0mrade's picture

Database password recovey  plays a major role during disaster recovery and much of the data is being lost without being recovered . As on date there isn't a reliable  procedure to recover dba password  , This

idea should be taken into consideration or the importance of saving password for future use should be emphasised while being setup .

0
Login to vote
Jeremy Dundon's picture

This is only an issue for the embedded database.

For an SQL database you can change the password at will.

0
Login to vote
Chetan Savade's picture

Yes it's for Embedded only.

SQL is third party software.

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

0
Login to vote
osama@protech-jo.com's picture

I had a same problem while I was going to repare SEP Manager.

Could you help me to reset DBA password please?

I have read previously the following article:

https://www-secure.symantec.com/connect/articles/how-find-database-password-odbc

but I couldn't login to  http://localhost:8014/reporting ( File Directory not found )

Please if any one hane an idea, I would be grateful.

ASAP  ASAP  ASAP :) :)

 

thanks,

0
Login to vote
Chetan Savade's picture

Hi,

You are facing problem with SEP 11.x or SEP 12.1 ?

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

0
Login to vote
rajeev rehan's picture

 we are using SEP 12.0. Log file is attached for reference...

AttachmentSize
SEPM_logs.zip 5.55 MB
0
Login to vote
Chetan Savade's picture

Try following link to recover Embedded database password

https://www-secure.symantec.com/connect/articles/h...

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

0
Login to vote
Dickson's picture

Dear all,

I search around this forum and try several method mentioned in forum. All of them do not work at all.

My problem is that I want to reset the password of embedded database (SEPM 12.1).

My case is that I reset once the admin password of SEPM via "resetpass" because I forget the initial password at all. Then I can login the Console to view all funcions and ....etc.  Later on, I want to reconfig the management server via "Management Server Configuration Wizard". It will ask me the "DBA"'s password but I forget it at all.

I think that the method in "How to find the Database password for Embedded Database" article is old or not applied in 12.1 version.

 

0
Login to vote
Chetan Savade's picture

Hi,

In SEP 12.1 there is not any supported method to recover the Embedded database password.

You must know the Embedded database password to successfully complete management server configuration wizard.

 

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

0
Login to vote
Dickson's picture

Thanks for Chetan's help.

The main point is how I can recover Embedded database password if I forget the Embedded database password.

0
Login to vote