Solved

Get into old sybase .db database without password

Posted on 2007-11-19
3
3,420 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 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
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 …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 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