Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Lost Admin password for DBA

3 posts in General Discussion Last posting was on 2006-08-15 20:44:10.0Z
akusastefan Posted on 2006-08-15 17:30:48.0Z
Sender: 2d7d.44e2020a.1804289383@sybase.com
From: akusastefan@att.net
Newsgroups: ianywhere.public.general
Subject: Lost Admin password for DBA
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44e2027f.2d92.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 15 Aug 2006 10:21:03 -0700, 10.22.241.42
Lines: 9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Aug 2006 10:21:06 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Aug 2006 10:30:48 -0700
X-Trace: forums-1-dub 1155663048 10.22.108.75 (15 Aug 2006 10:30:48 -0700)
X-Original-Trace: 15 Aug 2006 10:30:48 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5554
Article PK: 1591

Ok, we have a problem... we are running a retail store with
a Sybase database with our inventory, however, we've lost
the admin password and username to be able to change things
in the database. Is there ANY way to be able to find out
what the password and username is or change it ?

Thanks in advanced for ANY help.

Stefan


Robert Paresi Posted on 2006-08-15 17:58:44.0Z
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <44e2027f.2d92.1681692777@sybase.com>
Subject: Re: Lost Admin password for DBA
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: smtp.innquest.com
X-Original-NNTP-Posting-Host: smtp.innquest.com
Message-ID: <44e20b54@forums-1-dub>
Date: 15 Aug 2006 10:58:44 -0700
X-Trace: forums-1-dub 1155664724 24.173.150.22 (15 Aug 2006 10:58:44 -0700)
X-Original-Trace: 15 Aug 2006 10:58:44 -0700, smtp.innquest.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5555
Article PK: 1590

I hope not.

-Robert

<akusastefan@att.net> wrote in message
news:44e2027f.2d92.1681692777@sybase.com...
> Ok, we have a problem... we are running a retail store with
> a Sybase database with our inventory, however, we've lost
> the admin password and username to be able to change things
> in the database. Is there ANY way to be able to find out
> what the password and username is or change it ?
>
> Thanks in advanced for ANY help.
>
> Stefan


Jason Hinsperger (iAnywhere) Posted on 2006-08-15 20:44:10.0Z
From: "Jason Hinsperger \(iAnywhere\)" <NOjason_hinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <44e2027f.2d92.1681692777@sybase.com> <44e2116c@forums-2-dub>
Subject: Re: Lost Admin password for DBA
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: hinsperg-xp.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-xp.sybase.com
Message-ID: <44e2321a$1@forums-1-dub>
Date: 15 Aug 2006 13:44:10 -0700
X-Trace: forums-1-dub 1155674650 10.25.99.165 (15 Aug 2006 13:44:10 -0700)
X-Original-Trace: 15 Aug 2006 13:44:10 -0700, hinsperg-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5557
Article PK: 1592

I also want to add for those out there who want to prevent this, that if you
use strong encryption when you create your database, there is no way to
recover/reset the dba password. If you lose it, your data is gone (except
for brute forcing the key of course).

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
************************************************************
For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
************************************************************




"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>

wrote in message news:44e2116c@forums-2-dub...
> No, there is no way to pull passwords from a SQL Anywhere database. If
> you open a call with technical support and can prove that you are the
> owner of the database (easier said than done I should add), then
> development can hack into your database and reset the DBA password.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> <akusastefan@att.net> wrote in message
> news:44e2027f.2d92.1681692777@sybase.com...
>> Ok, we have a problem... we are running a retail store with
>> a Sybase database with our inventory, however, we've lost
>> the admin password and username to be able to change things
>> in the database. Is there ANY way to be able to find out
>> what the password and username is or change it ?
>>
>> Thanks in advanced for ANY help.
>>
>> Stefan
>
>