I'm trying to make access to the database sybase 9 and do not know the password dba access. How to recover the password for dba?
asked 23 Oct '12, 14:20
With the response that link could solve the problem ...
Thanks to all.
answered 24 Oct '12, 16:25
If you don't know the DBA password then you cannot recover it - the passwords are internally one-way hashed within the database. You have a few options:
1) If you have another account on the database with DBA authority then you could connect/login to that account and reset the DBA user's password.
2) If you have a backup of the database with a known password (for a user with DBA authority) then you can fall back to that copy.
3) If all else fails, you could try contacting Sybase tech support - see link at bottom of page - and if you can prove that you legally own the database and have rights to the data then they may be able to help you recover the database.
answered 23 Oct '12, 15:38
Quoting from another answer by Mark Culp:
If the database was created using a third-party software application then you should contact the vendor of that application in order to get the data out of the database.
If you can prove that the database belongs to you and that you have the rights to the data then Sybase Tech Support may be able to help you get a dump of the data in the SQL Anywhere database, but if the data is encrypted and you do not have the encryption password then there is no method of getting any of the data.
To contact Tech Support click on the "Contact Us" link at the bottom of this page and then click on "Support Contacts" on the right panel.
answered 23 Oct '12, 15:34