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.
   Note: When installing SQL Anywhere on a 64-bit version of Windows, you must install the 32-bit versions of the database and administration tools (see Windows 64-Bit Support).

   
   
   
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 authenticate.sql file delivered in the Setup\support directory of the installation media (and installed to the Tools directory of your PowerDesigner installation) to the \Scripts directory 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 authenticate.sql against it.

• Creating a Database to Contain the Repository
  Once you have installed SQL Anywhere, you must create an authenticated database on the repository server to which you will deploy the repository.