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.

  1. Select Start > Programs > SQL Anywhere 12 > Admin Tools > Sybase Central to open Sybase Central.
  2. Select Tools > SQL Anywhere 12 > Create Database to open the Create Database Wizard.
  3. Click Next to go to the Select a Location page. The Create a database on this computer option is automatically selected. Click Next to go to the Specify a Database File page.
  4. Enter an appropriate name for the database, and then click Next to go to the Specify the Transaction Log File page.
  5. Make sure the Maintain the Following Transaction Log File check box is selected, accept or specify an alternate log file name and location, and then click Next.
  6. Continue clicking Next and accepting the default settings until you arrive at the Specify DBA User and Password page.
  7. By default, the database is created with a super-user called DBA, and with a password "sql". Select these defaults or provide your own parameters, and then click Next to go to the Connect to the Database page.
    Note: You will need to enter this username and password in the repository definition (see Installing the Repository to the Server).
  8. Click Finish to create the database. A message box displays the progress and informs you when the creation is complete.