APE Database Setup Wizard

   

The APE Database Setup Wizard is the fastest way to create a new SQL Server database. The wizard consists of five main steps.

  1. Selecting a database server.

  2. Defining the system administrator login.

  3. Defining the destination directory.

  4. Defining the database owner.

  5. Finishing the database installation.

The wizard creates and installs the new APETEST database with one public user (the database owner) and the three APE test tables (Account, OrderDetails, and Products).

Note   The APE Database Setup Wizard does not handle error conditions. Any database setup errors will be displayed using ODBC syntax.

The wizard includes a standard set of buttons along the bottom. These buttons control the following actions.

Button Description
Help Displays online Help for the Project Wizard.
< Back Moves back one step in the process.
Next > Moves forward one step in the process.
Finish Creates all items and closes the wizard.
Cancel Closes the wizard; no database is created.

Please Select a Server

This step specifies the kind of database server you want. There is only one option:

Server Administrator Login

This step defines the database administrator. The login identified here must belong to an authorized database administrator with full access permissions.

Login Id

Provides a place to specify the administrator's login name.

Password

Provides a place to specify the administrator's password.

Server

Provides a place to specify the name of the new database server.

Destination Directory

This step defines directory, device, and file size for the new database server.

Device ID

Provides a place to specify the unique device identification for the database and transaction logs.

Device Size (MB)

Defines the approximate size of the database.

Server Device Path

Provides a place to specify the directory where the database will be created.

Who's the DBO?

This step defines the database owner.

Confirm password

Confirms the database owner's password.

Log on dbo id

Provides a place to specify the database owner. The default is APETESTER.

Password for log on

Provides a place to specify the database owner's password.

Finish

This step completes the wizard and displays a confirmation message indicating that the database was successfully installed.