Authenticating Databases

You must create a database to store the repository tables in the server. Only authenticated databases can be used with the authenticated version of SQL Anywhere supplied with PowerDesigner.

You can:

  • Authenticate new databases – by copying the contents of the script authdb.sql delivered with the repository under \Tools, into the file saopts.sql under \Script in the SQL Anywhere directory, on the server machine. The authentication string included in this file will automatically authenticate any new database for use with the repository as soon as you create it.

  • Authenticate existing databases - by executing the script authdb.sql delivered with the repository under \Tools.

  1. Start Interactive SQL (dbisql.exe), and enter dba in the User ID and sql in the Password fields.
  2. Enter the data source name in the ODBC Data Source Name box.
  3. Select the Database tab and click the Browse button.
  4. Double-click the existing database in the file selection window to display the file path in the Database File box, and click OK.

    The Interactive SQL window is displayed.

  5. Open the script authdb.sql and execute it.
  6. Close Interactive SQL and restart the server.

    Your database is now authenticated and you can use it with the repository.

Parent topic: Installing SQL Anywhere