Configuring the servers

StepsConfiguring Adaptive Server

  1. Select Yes when the Studio Installer prompts: “OK to configure component Adaptive Server Enterprise?”

    NoteIf you select No, the Studio Installer exits. You can complete the installation by invoking %SYBASE%\%SYBASE_ASE%\bin\syconfig.exe.

  2. Select Adaptive Server from the Products icons on the left.

    Figure 4-1: Configuring Sybase servers

  3. Click Create Adaptive Server.

  4. The Adaptive Server name is generated and supplied from the server machine ID.

    WARNING! Backup and XP Server do not allow hyphens in the name. Since XP and Backup Server names are automatically created from the Adaptive Server name, you must remove any hyphens before proceeding.

    Click Continue.

  5. Select the logical page size for this installation. Valid options are 2K, 4K, 8K, and 16K.

  6. Specify the size and location of the master device, master.dat.

    The default is based on the logical page size. The minimum allowable size is 25MB.

    The default directory is: %SYBASE%\data\master.dat.

  7. Specify the size and location of sybsystemprocs.dat. The default value of 100MB is the minimum required and the recommended size. Because the sybsystemprocs database is constantly increasing in size, this allows enough space on the device for growth.

  8. Select Network Connection and click Add.

  9. Enter a valid IP address, or the server name and port number.

  10. Click Continue.

  11. Provide an error log path name. The default is:


  12. From this window, you must also configure the XP Server. Select Configure Default XP Server.

    Figure 4-2: Adaptive Server options

  13. You can select either System Account (default) or This Account. To enable MAIL support in Adaptive Server, you must select This Account, change the NT account from LocalSystem to a valid account, and provide a password. See the Adaptive Server Configuration Guide.

  14. Select Network Address. This launches the network connection information screen.

    A valid network IP address or host_name and port_number is required to complete the installation and configuration of Sybase servers. For example:

    machine_name port_number



    NoteBeginning with version 12.5, Adaptive Server accepts TCP connection formats on Windows platforms. See Chapter 6, “Installing Sybase PC-Client Products.”

  15. Provide an error log path name.

    The default is:


    From this window, you can also set command-line parameters. Command-line parameters set parameters for every instance of the server.

  16. When you complete the setup process, click Continue.

    This returns you to the Configure Sybase Servers screen where you can select Monitor Server or the Backup Server icons to continue the installation process.

    You can set up servers to start automatically. For details, see Chapter 7, “Starting and Stopping Servers.”

StepsConfiguring Backup Server

This procedure assumes that you have completed the “Pre-installation tasks”.

  1. Select Backup Server from the icons on the left, and select Create Backup Server. The Backup Server attribute screen displays.

  2. The related Backup Server name is provided by default. It is the same name as the Adaptive Server with the extension “_BS”. This is the name of the Adaptive Server that will use this Backup Server.

    Click Continue.

  3. Provide an error log path for Backup Server.

  4. Specify the language you want Backup Server to use for its error messages. The default language is U.S. English.

    The language available depends on which language modules were installed on your system. By default, all character sets are copied from the CD when performing a standard or full install.

  5. Specify the character set you want Backup Server to use.

    The default character set is cp850.

    Other options are:

  6. Click Network Addresses.

  7. Click Add.

  8. Enter a valid IP address and a unique port number.

  9. Click Continue.

  10. The installer displays the message “The New Backup Server Configuration is Finished.” Click Continue.

  11. Do one of the following:

StepsConfiguring Monitor Server

This procedure assumes that you have completed the “Pre-installation tasks”.

  1. Select Monitor Server from the icons on the left, then select Create Monitor Server.

    The Monitor Server name is provided by default. It is the same name as the Adaptive Server with the extension “_MS”.

  2. Provide an error log path, or accept the default.

  3. If the Monitor Server is created in the same configuration session as Adaptive Server, you do not have to specify additional network addresses.

    If you create a new Monitor Server that does not correspond with an Adaptive Server, you must add a network connection. Click Network Addresses.

  4. Click Continue. The installation program:

    When the process is completed, the FINISHED window displays. The 2.4MB of disk space used by the installation program for temporary files is released when installation is complete.

StepsConfiguring EJB Server

You can modify the port number in the file, %SYBASE%\%$SYBASE_EJB%\Repository\Listener\EJBServer_iiops.props.

  1. Enter a valid port number, and click Next.

  2. The utility displays the message: “Configuration of Installed Products is Complete.” Click OK.

  3. The utility displays the message: “Install Complete.” Click OK.

Adaptive Server and related products have been successfully installed, and minimally configured for use. See “Installing sample databases”, to begin experimenting with your servers, or see the System Administration Guide for more advanced topics.

Adaptive Server

You have a running server, as well as various system databases and system tables. Some references that may help you get started using your new Adaptive Server are:

Backup Server

For information on developing a backup and recovery plan and backing up and restoring user databases, see the System Administration Guide.

Monitor Server

Monitor Server requires some additional configuration after installation. See the Adaptive Server Enterprise Monitor Server User’s Guide.

XP Server

For information on using extended stored procedures, see the Transact-SQL User’s Guide.