How are we supposed to use our SQL Anywhere 17.0 license keys

[Former Member]

Dear SAP,

A few weeks ago, I obtained a license key for SQL Anywhere 17.0.

This key was intended for our database programmer to create tables and

A new database product for testing. I generated the key on my computer,

And then our database programmer used it on her computer.

She then used the key to install her SQL Anywhere 17.0. When she tried to

Generate a table with this key, she got an “Authentication Violation”

SQLCODE = -98

As a result, she reinstalled SQL Anywhere 17.0 on her computer, this

Time without using any key at all, and was able to create her tables

Without an error message.

The question I have is this—

How are we supposed to use our SQL Anywhere 17.0 license keys

(all in the windows OS), when we are creating a new product?

How can I give our database programmer a key that will

Allow her new database to run properly on the computers of

Other developers who will need to connect to it?

Should they also have keys?

Currently, we are using Sybase 17.0.8.4103.

Is this the most recent version of Sybase 17?

We note that our database programmer sees her

Logon name when she creates SQL Anywhere tables,

Not DBA. How can we get this entry to

Be DBA?

[former_member182948]

Please see the following KBA for this error.

2093581 - SAP SQL Anywhere Error : "Authentication violation" -98
https://launchpad.support.sap.com/#/notes/2093581

[former_member462491]

Hi Charles,

This error indicates that you have an "OEM Authenticated Edition" license and either the "database_authentication" option was not set on the database or your client application does not authenticate itself. Since your developer can connect to the same database with developer license, it seems like you did not authenticate the database. You can read more about it in this section of documentation.

Other developers can use the same license key. Note that they will need to connect with authenticated application. Administrative tools included with SQL Anywhere do not need any additional authentication.

17.0.8.4103 is the most recent version.

The last question depends on how she connects. Is she using your application to connect or one of SQL Anywhere administration tools? If it is your application, are you using integrated login or does user need to input uid/password?

If you still have questions, please consider having a chat with Product support.

Regards,
Evgeniya