Show TOC

Connecting to a DatabaseLocate this document in the navigation structure


This procedure enables you to connect to a remote database and display an installed AS Java configuration.

  1. Start the Config Tool by double-clicking the configtool script file in <SAP_install_dir>/<system_name>/<instance_name>/j2ee/configtool directory.

  2. In the Connection settings dialog window, choose " Yes " if you want to connect to the default database, or " No " to connect to a different one.

    The default database connection is via the Secure Store.


    If you check the " Do not ask me again " indicator, next time you start the Config Tool, it will automatically connect to the default database.

    To connect to a different database, you can remove the file from the configtool directory. Then, start the Config Tool.

  3. In the Connect dialog window, choose whether to connect via secure store or via direct login and enter the required data in the relevant fields.

Secure Store Settings



Secure Store File

Contains the path to the secure store properties file. This file is encrypted for security reasons.


Secure Store Key File

Contains the path to the secure store key file. The key file contains the password for the encrypted store file.


System Name

Displays the name of the system to which this data applies.


Secure Store Lib

Specifies the security directory. It contains IAIK JAR files you need to use to open the Secure Store.


RDBMS Connections

A property key, by which the value contains the DB connection settings.


Direct Login Settings




Specifies the URL for the database connection in the correct format for the corresponding driver.


Driver name

Specifies the class name of the JDBC driver to be used for database connections.

RDBMS user

Specifies the user name for this database connection.


RDBMS password

Specifies the password set during the installation of the relevant AS Java.


IAIK Library

Specifies the IAIK JAR files directory. It enables the encrypting and decrypting of the properties file.

;C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_jce.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_jsse.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_smime.jar; C:\usr\sap\LKG\SYS\global\security\lib\tools\iaik_ssl.jar

General Settings



RDBMS Driver Location

Contains the path to the RDBMS driver.


RDBMS Initial Connections

Specifies the number of database connections to be created initially in the connection pool.


RDBMS Maximum Connections

Specifies the maximum number of database connections to be kept in the connection pool.


After filling in the connection fields, you have the following options:

  • Directly connect to the relevant database. Choose Connect to DB .

  • Save the connection properties you have just set as following:

    1. Choose Save Connection As .

    2. Enter a file name with the extension " .properties ", for example .

    3. Choose Save .

  • Open a previously saved " .properties " file to connect to a database. Choose Load Connection Settings .


You have successfully connected to a database.

After opening the GUI Config Tool, you can proceed the following steps for better future use:

  • If you want the Connection settings dialog box to appear again on startup, choose Start of the navigation path View Next navigation step Startup Options. End of the navigation path. Then, in the dialog window, check Show connection dialog .

    The other way is to delete the file. Then, start the Config Tool.

  • If you use a Linux or Unix operating system, choose Start of the navigation path View Next navigation step Startup Options End of the navigation path. Then, in the dialog box, check Use loading indicator .

    This is necessary for the system to provide a better performance of the GUI Config Tool when you work with instances.


    If you are not available to proceed this via the GUI tool, in the configtool folder, open the file for text editing. Then, add the line: show.loading.indicator=YES .