Authentication failed

[Former Member]

Grettings,

When migrating from version 8 to sql anywhere version 11, I get the following error:

SQL Anywhere Unload Utility Version 11.0.1.2324
Connecting and initializing
Unloading user and group definitions
Unloading table definitions
Unloading index definitions
Unloading functions
Unloading view definitions
Unloading procedures
Unloading triggers
Unloading SQL Remote definitions
Unloading MobiLink definitions
Creating new database
***** SQL error: Authentication failed

What could be the cause of this and how can I fix it?

My searches lead me to the following documentation: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/dbopti... But this only seems to work for the OEM version of the application and I don't believe the installation I need to migrate to is an OEM version...

[Breck_Carter · Accepted solution]

If you got that message then you probably ARE executing an authenticated copy of SQL Anywhere 11.

See this Help topic: Upgrading authenticated databases

[Former Member · Accepted solution]

Thanks for the information. I guess I was looking in the right direction then. I'll have to get the database_authentication string and do what's in that documentation.

[VolkerBarth · Accepted solution]

Is the old database authenticated, too?

If so, AFAIK usually the old and new signatures should be the same...