Test Connecting to Data Sources


Overview

Tasks

Included with

Tivoli Service Desk

Overview

Test connecting

You can test whether your data source configuration enables you to connect to the database while you are in the process of configuring your data source.

Database Logon dialog box

During a test connection, use the Database Logon dialog box to provide the user ID (UID) and password (PWD) required to connect you to your database server.

To access the Database Logon dialog box:


Tasks

Testing a data source connection

To test a data source connection:
  1. In the SQL Configuration Editor dialog box, from the Sources list, select a data source and choose Test Connect.
  2. In the Database Logon dialog box, supply the user ID and password required to connect you to your database server.
    Note: The Database Logon dialog box does not appear if your user ID and password appear in the Source Setup dialog box. This user ID and password may or may not be the same as your network user ID and password. Also, your database user ID and password may differ from your TSD user ID and password. See your database administrator if you don't know your database user ID or password.
  3. Choose OK.
    Result: If the connection is successful, the Test Connect message appears. If connectivity is not established, you see an error message.
  4. Did you receive a successful connection message?
    • If yes, choose OK.
    • If no, check the parameters in the Source Setup Dialog box or test the connectivity with the SQL tool specific to your DBMS.
  5. Do you need to configure the data source for additional client workstations?