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
8.6k116151237
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:

×19
×14
×11
×8

question asked: 19 Aug '13, 04:50

question was seen: 2,091 times

last updated: 19 Aug '13, 09:21