[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Get into old sybase .db database without password

Posted on 2007-11-19
3
Medium Priority
?
3,557 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 2000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

With the evolution of technology, we have finally reached a point where it is possible to have home automation features like having your thermostat turn up and door lock itself when you leave, as well as a complete home security system. This is a st…
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

650 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