Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi, i'm trying to reload an Authenticated OEM database with a new page size but when using dbunload I get an authentication violation error message.

dbunload.exe -c "DBF=C:DatabasesDB01database.db;UID=dba;PWD=..." -an "C:DatabasesDB02database.db" -ap 32768 Adaptive Server Anywhere Unload Utility Version 9.0.2.3923 * SQL error: Authentication violation

Is this normal, or is there something else I have to do?

Note: I have also tried creating the database setting the database_authentication then using an external unload, external reload with the same results. I obtained the authentication strings using the following SQL:

SELECT * FROM sa_conn_properties() WHERE PropName IN ('database_authentication', 'connection_authentication')

The application i'm doing this for is licenced i'm just supporting it for a client.

asked 19 Aug '13, 04:50

Robert2's gravatar image

Robert2
91348
accept rate: 0%


You can use a script file to provide the authentication string for new created databases (like done by dbunload) the script for 9.0.2 should be %SQLANY9%\scripts\saopts.sql for newer versions it is %SQLANY10%\scripts\authenticate.sql
see also Upgrading authenticated databases

permanent link

answered 19 Aug '13, 04:59

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

edited 19 Aug '13, 05:01

I added "SET OPTION PUBLIC.DATABASE_AUTHENTICATION = '...';" with the database_authentication string I extracted from the DB to the top of the saops.sql file and run then dbuload. I recived the same error message authentication violation.

(19 Aug '13, 05:15) Robert2

Please set this value in the existing DATABASE_AUTHENTICATION block of that file. If you added the entry at the start of the file, it gets overwritten by that existing block.

(19 Aug '13, 09:21) Chris Keating
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:

×24
×17
×14
×13

question asked: 19 Aug '13, 04:50

question was seen: 4,260 times

last updated: 19 Aug '13, 09:21