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.

SQL Anywhere 11 created DBA can't manage database

5 posts in General Discussion Last posting was on 2009-02-17 20:46:38.0Z
mark s Posted on 2009-02-17 15:32:32.0Z
Sender: 1eac.4999db0f.1804289383@sybase.com
From: mark s
Newsgroups: ianywhere.public.general
Subject: SQL Anywhere 11 created DBA can't manage database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499ad88f.318b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Feb 2009 07:32:32 -0800
X-Trace: forums-1-dub 1234884752 10.22.241.41 (17 Feb 2009 07:32:32 -0800)
X-Original-Trace: 17 Feb 2009 07:32:32 -0800, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7361
Article PK: 5776

I was converting a SQL Anywhere 9 database to 11 trying to
use
the Unload. I kept getting an Authentication error.

After trying several things I simply ran dbinit (sql
anywhere
11) and have tried manipulating the database. Even logged
in as
DBA, sql. I got logged in fine, but other than setting a
few
options, I can't do any GRANT's or create table commands.
It's
like I don't have DBA authority even though I logged into
the
database (isql) using DBA login.


I have tried so many things including making sure the
license
key is setup.

This is frustrating at this point and we have used SQL
Anywhere 9
for a long time.

Appreciate the help.
is set.


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-02-17 15:54:40.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 11 created DBA can't manage database
References: <499ad88f.318b.1681692777@sybase.com>
In-Reply-To: <499ad88f.318b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <499addc0$1@forums-1-dub>
Date: 17 Feb 2009 07:54:40 -0800
X-Trace: forums-1-dub 1234886080 10.22.241.152 (17 Feb 2009 07:54:40 -0800)
X-Original-Trace: 17 Feb 2009 07:54:40 -0800, vip152.sybase.com
Lines: 39
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7362
Article PK: 5778

Have you setup the authenticate.sql file as per the documentation. It
should contain the database_authentication option. If this does not
exist or the option is not defined correctly, the database file with not
be authenticated during the unload - and will result in the error seen.
NOTE: In SA9, the option would be defined in the saopts.sql.

For more info, please review the documentation via the index
"authenticated applications".

mark s wrote:
> I was converting a SQL Anywhere 9 database to 11 trying to
> use
> the Unload. I kept getting an Authentication error.
>
> After trying several things I simply ran dbinit (sql
> anywhere
> 11) and have tried manipulating the database. Even logged
> in as
> DBA, sql. I got logged in fine, but other than setting a
> few
> options, I can't do any GRANT's or create table commands.
> It's
> like I don't have DBA authority even though I logged into
> the
> database (isql) using DBA login.
>
>
> I have tried so many things including making sure the
> license
> key is setup.
>
> This is frustrating at this point and we have used SQL
> Anywhere 9
> for a long time.
>
> Appreciate the help.
> is set.


mark s Posted on 2009-02-17 16:55:14.0Z
Sender: 1eac.4999db0f.1804289383@sybase.com
From: Mark S
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 11 created DBA can't manage database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499aebf2.33e0.1681692777@sybase.com>
References: <499addc0$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Feb 2009 08:55:14 -0800
X-Trace: forums-1-dub 1234889714 10.22.241.41 (17 Feb 2009 08:55:14 -0800)
X-Original-Trace: 17 Feb 2009 08:55:14 -0800, 10.22.241.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7363
Article PK: 5781

Chris - thanks, that got me checking..

We don't use "authenticated" database. (that I know of).
That being said, I am downloading the 11.0 Base Entitlement
Only
package. Will that allow me to run the database as
unauthenticated?

Or is there a way to setup authenticate.sql to not require
an authenticated database?

Thanks,
Mark

> Have you setup the authenticate.sql file as per the
> documentation. It should contain the
> database_authentication option. If this does not exist or
> the option is not defined correctly, the database file
> with not be authenticated during the unload - and will
> result in the error seen. NOTE: In SA9, the option would
> be defined in the saopts.sql.
>
> For more info, please review the documentation via the
> index "authenticated applications".
>
>
>
> mark s wrote:
> > I was converting a SQL Anywhere 9 database to 11 trying
> > to use
> > the Unload. I kept getting an Authentication error.
> >
> > After trying several things I simply ran dbinit (sql
> > anywhere
> > 11) and have tried manipulating the database. Even
> > logged in as
> > DBA, sql. I got logged in fine, but other than setting
> > a few
> > options, I can't do any GRANT's or create table
> > commands. It's
> > like I don't have DBA authority even though I logged
> > into the
> > database (isql) using DBA login.
> >
> >
> > I have tried so many things including making sure the
> > license
> > key is setup.
> >
> > This is frustrating at this point and we have used SQL
> > Anywhere 9
> > for a long time.
> >
> > Appreciate the help.
> > is set.


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-02-17 18:28:47.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 11 created DBA can't manage database
References: <499addc0$1@forums-1-dub> <499aebf2.33e0.1681692777@sybase.com>
In-Reply-To: <499aebf2.33e0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <499b01df$1@forums-1-dub>
Date: 17 Feb 2009 10:28:47 -0800
X-Trace: forums-1-dub 1234895327 10.22.241.152 (17 Feb 2009 10:28:47 -0800)
X-Original-Trace: 17 Feb 2009 10:28:47 -0800, vip152.sybase.com
Lines: 65
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7364
Article PK: 5780

If you are getting a -98 (Authentication Violation) or -218
(Authentication Failed) error code, the engine you are running is an
authenticated edition. It would require an authenticated database and
each connection be authenticated. If you are an OEM that includes SQL
Anywhere, you will be required to use the authenticated engine per the
terms of your agreements. Your sales rep can confirm the details for you.

Mark S wrote:
> Chris - thanks, that got me checking..
>
> We don't use "authenticated" database. (that I know of).
> That being said, I am downloading the 11.0 Base Entitlement
> Only
> package. Will that allow me to run the database as
> unauthenticated?
>
> Or is there a way to setup authenticate.sql to not require
> an authenticated database?
>
> Thanks,
> Mark
>
>
>> Have you setup the authenticate.sql file as per the
>> documentation. It should contain the
>> database_authentication option. If this does not exist or
>> the option is not defined correctly, the database file
>> with not be authenticated during the unload - and will
>> result in the error seen. NOTE: In SA9, the option would
>> be defined in the saopts.sql.
>>
>> For more info, please review the documentation via the
>> index "authenticated applications".
>>
>>
>>
>> mark s wrote:
>>> I was converting a SQL Anywhere 9 database to 11 trying
>>> to use
>>> the Unload. I kept getting an Authentication error.
>>>
>>> After trying several things I simply ran dbinit (sql
>>> anywhere
>>> 11) and have tried manipulating the database. Even
>>> logged in as
>>> DBA, sql. I got logged in fine, but other than setting
>>> a few
>>> options, I can't do any GRANT's or create table
>>> commands. It's
>>> like I don't have DBA authority even though I logged
>>> into the
>>> database (isql) using DBA login.
>>>
>>>
>>> I have tried so many things including making sure the
>>> license
>>> key is setup.
>>>
>>> This is frustrating at this point and we have used SQL
>>> Anywhere 9
>>> for a long time.
>>>
>>> Appreciate the help.
>>> is set.


mark s Posted on 2009-02-17 20:46:38.0Z
Sender: 1eac.4999db0f.1804289383@sybase.com
From: Mark S
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere 11 created DBA can't manage database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499b222e.386b.1681692777@sybase.com>
References: <499b01df$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Feb 2009 12:46:38 -0800
X-Trace: forums-1-dub 1234903598 10.22.241.41 (17 Feb 2009 12:46:38 -0800)
X-Original-Trace: 17 Feb 2009 12:46:38 -0800, 10.22.241.41
Lines: 79
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7365
Article PK: 5785

Chris - thanks again...

I'm getting a -98 (Authentication Violation) error.

I have a request into the sales rep. But you could help,
can you tell me what a Base Entitlement Only download is?
The one giving me the -98 error is an OEM. And yes I am
an OEM.

Thanks for all the help.
Mark

> If you are getting a -98 (Authentication Violation) or
> -218 (Authentication Failed) error code, the engine you
> are running is an authenticated edition. It would
> require an authenticated database and each connection be
> authenticated. If you are an OEM that includes SQL
> Anywhere, you will be required to use the authenticated
> engine per the terms of your agreements. Your sales rep
> can confirm the details for you.
>
>
> Mark S wrote:
> > Chris - thanks, that got me checking..
> >
> > We don't use "authenticated" database. (that I know of).
> > That being said, I am downloading the 11.0 Base
> > Entitlement Only
> > package. Will that allow me to run the database as
> > unauthenticated?
> >
> > Or is there a way to setup authenticate.sql to not
> > require an authenticated database?
> >
> > Thanks,
> > Mark
> >
> >
> >> Have you setup the authenticate.sql file as per the
> >> documentation. It should contain the
> >> database_authentication option. If this does not exist
> or >> the option is not defined correctly, the database
> file >> with not be authenticated during the unload - and
> will >> result in the error seen. NOTE: In SA9, the
> option would >> be defined in the saopts.sql.
> >>
> >> For more info, please review the documentation via the
> >> index "authenticated applications".
> >>
> >>
> >>
> >> mark s wrote:
> >>> I was converting a SQL Anywhere 9 database to 11
> trying >>> to use
> >>> the Unload. I kept getting an Authentication error.
> >>>
> >>> After trying several things I simply ran dbinit (sql
> >>> anywhere
> >>> 11) and have tried manipulating the database. Even
> >>> logged in as
> >>> DBA, sql. I got logged in fine, but other than
> setting >>> a few
> >>> options, I can't do any GRANT's or create table
> >>> commands. It's
> >>> like I don't have DBA authority even though I logged
> >>> into the
> >>> database (isql) using DBA login.
> >>>
> >>>
> >>> I have tried so many things including making sure the
> >>> license
> >>> key is setup.
> >>>
> >>> This is frustrating at this point and we have used SQL
> >>> Anywhere 9
> >>> for a long time.
> >>>
> >>> Appreciate the help.
> >>> is set.