The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.6k114149237
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:

×18
×14
×11
×8

question asked: 19 Aug '13, 04:50

question was seen: 1,961 times

last updated: 19 Aug '13, 09:21