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/dboptions-s-4985733.html 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...

asked 03 Oct '13, 08:18

AndyPPW's gravatar image

AndyPPW
85339
accept rate: 0%

edited 03 Oct '13, 08:21


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

See this Help topic: Upgrading authenticated databases

permanent link

answered 03 Oct '13, 08:49

Breck%20Carter's gravatar image

Breck Carter
26.8k420580826
accept rate: 20%

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.

(03 Oct '13, 09:15) AndyPPW
Replies hidden

Is the old database authenticated, too?

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

(03 Oct '13, 09:18) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×18

question asked: 03 Oct '13, 08:18

question was seen: 615 times

last updated: 03 Oct '13, 09:18