Solved

Get into old sybase .db database without password

Posted on 2007-11-19
3
3,385 Views
Last Modified: 2012-06-27
We have an old .db database that the password is lost on.  Is there a tool to get into it.
0
Comment
Question by:rrococi2
3 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 20321719
First, try the default:  UID=DBA, PWD=SQL  and see if that works.  You'd be surprised how many times people don't change that.

Next, call tech support.  There may well be a procedure for recovering a database with a lost DBA password like there is for Sybase ASE.  I have not seen it published though.

Next, try guessing the password for DBA.  Use company names, product names, names of people who did the original install and/or administration.  If that does not work, you will have to get clever.

I have never done it for SQL Anywhere but have had success on a couple of password protected file-based apps hauling out a good hex editor and fiddling with it that way.

The technique in general requires you to create a new, empty database with a known password.  Then create another identical database with a different password.  Then hex diff the two files.  You should find the db name, maybe the creation date, and the password as the differences.  Then change the password on one of them and compare them again.  This should give you an exact offset, or at least enough context to find the password in your old .DB file.

After making a copy of the file, hex edit it and stuff the known, encoded password
string from one of the other databases into the old one.  The fire it up and see if the known password does not work.

You may have problems since the length of the password can vary.  You might have to go through and set known passwords of several different lengths in the new database before you find the matching length in the old database.  Start with a clean copy of the old database each time.

Best of luck,
Bill
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question