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.

DBA password lost

7 posts in General Discussion Last posting was on 2006-06-26 06:12:47.0Z
Robin Posted on 2006-06-21 08:38:45.0Z
From: "Robin" <.@iol.it>
Newsgroups: ianywhere.public.general
Subject: DBA password lost
Lines: 14
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.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 83.103.21.2
X-Original-NNTP-Posting-Host: 83.103.21.2
Message-ID: <44990595$1@forums-1-dub>
Date: 21 Jun 2006 01:38:45 -0700
X-Trace: forums-1-dub 1150879125 83.103.21.2 (21 Jun 2006 01:38:45 -0700)
X-Original-Trace: 21 Jun 2006 01:38:45 -0700, 83.103.21.2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5444
Article PK: 1490

Help me please!

In ASA 9.0.2.3288 after the reload of a unloaded DB I can no longer access as DBA.

The reload files are no longer usable because in the meanwhile the DB has been modified.

The other users present in the old DB work regularly; among these ones there is one able to backup but none has the privileges to
execute a new unload.

Is it possible to recover or reset the password of DBA or another way to recover the control of DB?

Thank you in advance.


species8472 Posted on 2006-06-21 09:02:41.0Z
From: species8472 <species8472@ergens.op.het.net>
User-Agent: Thunderbird 1.5.0.4 (X11/20060614)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: DBA password lost
References: <44990595$1@forums-1-dub>
In-Reply-To: <44990595$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 212.136.106.126
Message-ID: <44990a2b@forums-2-dub>
X-Original-Trace: 21 Jun 2006 01:58:19 -0700, 212.136.106.126
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Jun 2006 01:58:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Jun 2006 02:02:41 -0700
X-Trace: forums-1-dub 1150880561 10.22.108.75 (21 Jun 2006 02:02:41 -0700)
X-Original-Trace: 21 Jun 2006 02:02:41 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5445
Article PK: 1489


Robin wrote:
> Help me please!
>
> In ASA 9.0.2.3288 after the reload of a unloaded DB I can no longer access as DBA.
>
> The reload files are no longer usable because in the meanwhile the DB has been modified.
>
> The other users present in the old DB work regularly; among these ones there is one able to backup but none has the privileges to
> execute a new unload.
>
> Is it possible to recover or reset the password of DBA or another way to recover the control of DB?
>
> Thank you in advance.
>
>

contact techsupport, with the necessary paperwork they can help you

joop

--
Mentat, Sybase Professional Services

Scenery is here, wish you were beautiful.


Breck Carter [Team iAnywhere] Posted on 2006-06-21 11:34:21.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: DBA password lost
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com>
References: <44990595$1@forums-1-dub> <44990a2b@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: host06.hourh.hyatthsiagx.com
X-Original-Trace: 21 Jun 2006 04:29:58 -0700, host06.hourh.hyatthsiagx.com
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Jun 2006 04:29:59 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Jun 2006 04:34:21 -0700
X-Trace: forums-1-dub 1150889661 10.22.108.75 (21 Jun 2006 04:34:21 -0700)
X-Original-Trace: 21 Jun 2006 04:34:21 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5447
Article PK: 1492

On 21 Jun 2006 02:02:41 -0700, species8472

<species8472@ergens.op.het.net> wrote:

>Mentat

Cool! did the Tleilaxu make you?

Breck The Twisted

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Rob Waywell Posted on 2006-06-21 14:29:12.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <44990595$1@forums-1-dub> <44990a2b@forums-2-dub> <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com>
Subject: Re: DBA password lost
Lines: 47
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: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <449957b8@forums-1-dub>
Date: 21 Jun 2006 07:29:12 -0700
X-Trace: forums-1-dub 1150900152 10.25.98.235 (21 Jun 2006 07:29:12 -0700)
X-Original-Trace: 21 Jun 2006 07:29:12 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5448
Article PK: 1493

Please tell me you at least had to look up the spelling of "Tleilaxu"?!

Robin - Support may be able to help you salvage the data out of the
database, but we can not reset a DBA password. Since the reload process
recreates the users, including users with DBA authority, with the same
passwords they had before the unload, something seems to be missing in your
problem description.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com...
> On 21 Jun 2006 02:02:41 -0700, species8472
> <species8472@ergens.op.het.net> wrote:
>
>>Mentat
>
> Cool! did the Tleilaxu make you?
>
> Breck The Twisted
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2006-06-22 10:46:59.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: DBA password lost
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <kqsk929h4rosjemgggl69k9q8a1d66u4u8@4ax.com>
References: <44990595$1@forums-1-dub> <44990a2b@forums-2-dub> <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com> <449957b8@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: host06.hourh.hyatthsiagx.com
X-Original-Trace: 22 Jun 2006 03:42:31 -0700, host06.hourh.hyatthsiagx.com
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Jun 2006 03:42:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Jun 2006 03:46:59 -0700
X-Trace: forums-1-dub 1150973219 10.22.108.75 (22 Jun 2006 03:46:59 -0700)
X-Original-Trace: 22 Jun 2006 03:46:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5456
Article PK: 1501

On 21 Jun 2006 07:29:12 -0700, "Rob Waywell"

<rwaywell_no_spam_please@ianywhere.com> wrote:

>Please tell me you at least had to look up the spelling of "Tleilaxu"?!

Worse... copy and paste :)

Breck Harkonnen

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Robin Posted on 2006-06-24 10:18:10.0Z
From: "Robin" <.@iol.it>
Newsgroups: ianywhere.public.general
References: <44990595$1@forums-1-dub> <44990a2b@forums-2-dub> <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com> <449957b8@forums-1-dub>
Subject: Re: DBA password lost
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Original-NNTP-Posting-Host: 217-133-83-190.b2b.tiscali.it
Message-ID: <449d104c@forums-2-dub>
X-Original-Trace: 24 Jun 2006 03:13:32 -0700, 217-133-83-190.b2b.tiscali.it
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jun 2006 03:13:32 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jun 2006 03:18:10 -0700
X-Trace: forums-1-dub 1151144290 10.22.108.75 (24 Jun 2006 03:18:10 -0700)
X-Original-Trace: 24 Jun 2006 03:18:10 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5469
Article PK: 1515

Thank you Rob.

I have already contacted the sybase support. I am waiting for reply.

I don't need to reset DBA password, but recover data.

I have tried to unload data startig db with "-gl all" swicth but without success (user can't select from SYSUSERPERM).

So wait again.

Thanks.

"Rob Waywell" <rwaywell_no_spam_please@ianywhere.com> ha scritto nel messaggio news:449957b8@forums-1-dub...

> Please tell me you at least had to look up the spelling of "Tleilaxu"?!
>
> Robin - Support may be able to help you salvage the data out of the database, but we can not reset a DBA password. Since the
> reload process recreates the users, including users with DBA authority, with the same passwords they had before the unload,
> something seems to be missing in your problem description.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in message
> news:s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com...
>> On 21 Jun 2006 02:02:41 -0700, species8472
>> <species8472@ergens.op.het.net> wrote:
>>
>>>Mentat
>>
>> Cool! did the Tleilaxu make you?
>>
>> Breck The Twisted
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com
>
>


species8472 Posted on 2006-06-26 06:12:47.0Z
From: species8472 <species8472@ergens.op.het.net>
User-Agent: Thunderbird 1.5.0.4 (X11/20060614)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: DBA password lost
References: <44990595$1@forums-1-dub> <44990a2b@forums-2-dub> <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com>
In-Reply-To: <s8bi92drdhl38vpq303h9ac0he1kjk4icb@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.136.106.126
X-Original-NNTP-Posting-Host: 212.136.106.126
Message-ID: <449f7adf$1@forums-1-dub>
Date: 25 Jun 2006 23:12:47 -0700
X-Trace: forums-1-dub 1151302367 212.136.106.126 (25 Jun 2006 23:12:47 -0700)
X-Original-Trace: 25 Jun 2006 23:12:47 -0700, 212.136.106.126
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5470
Article PK: 1517


Breck Carter [Team iAnywhere] wrote:
> On 21 Jun 2006 02:02:41 -0700, species8472
> <species8472@ergens.op.het.net> wrote:
>
>> Mentat
>
> Cool! did the Tleilaxu make you?
>
> Breck The Twisted
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com

If I say yes, how scary is that? :-)

--
Mentat, Sybase Professional Services

Staff meeting in the conference room in 3 minutes.