Deprecated: Function ereg() is deprecated in /rscs/rs/websites/lmpx.com/code/nav/common.inc on line 82

From:	Mark S	Date:	Tue Feb 17 20:46:38 2009
Subject:	Re: SQL Anywhere 11 created DBA can't manage database

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.