Installing and Authenticating SQL Anywhere

The PowerDesigner repository is delivered with an authenticated version of Sybase SQL Anywhere, which can only be used to store your PowerDesigner model repository. Note that the trial version of PowerDesigner is supplied with a lighter version of SQL Anywhere, for which the setup may be slightly different.

  1. Insert the software CD-ROM in the drive, and click the Install SQL Anywhere button. Choose your setup language, and then click Next to open the SQL Anywhere InstallShield wizard.
  2. Click Next to go to the license agreement page. Select your country or region, review and accept the license terms, and then click Next to go to the Custom Setup.
  3. Leave all the defaults, click Next, and then click Install to start the installation.

    installasa1
  4. When the installation is complete, you will be invited to view the ReadMe and online resources. Make your choices, and then click Finish to exit the wizard
  5. Copy the contents of the authdb.sql file delivered in the Setup\support directory of the installation media (and in the Tools directory of your PowerDesigner installation) into the file \Script\optdeflt.sql in your SQL Anywhere installation on the repository server.

    Copying these statements in this way ensure that when you create a database, it will automatically be authorized for use with the PowerDesigner repository.

    Note: If you create a database before having copied the authentication instructions in this way, then you will need to authenticate it manually by opening the Interactive SQL tool, logging into your database, and running the contents of authdb.sql against it.