Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

Walmir%20Taques's gravatar image

Walmir Taques
690374151
accept rate: 12%


With the response that link could solve the problem ...

http://sqlanywhere-forum.sap.com/questions/6636/decrypt-dsn-password-enp-to-pwd

Thanks to all.

permanent link

answered 24 Oct '12, 16:25

Walmir%20Taques's gravatar image

Walmir Taques
690374151
accept rate: 12%

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.

permanent link

answered 23 Oct '12, 15:38

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

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.

permanent link

answered 23 Oct '12, 15:34

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124
accept rate: 54%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×15

question asked: 23 Oct '12, 14:20

question was seen: 19,809 times

last updated: 24 Oct '12, 16:25