Chapter 3 Installing the Repository


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:

Steps To execute the authdb.sql script on an existing database:

  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.

 


Copyright (C) 2008. Sybase Inc. All rights reserved.