Troubleshooting data source connection errors

A test connection to the data source server might return an error for several reasons. There are actions that you can take to determine why the error occurred.

Symptom

An error is returned when you attempt to connect to the data source.

Cause

There are several possible causes for a connection problem.

Resolving the problem

To troubleshoot data source connection errors, check the following items for problems:

  • Verify that the data source is available.
  • Verify the data source can be accessed from Federation Server.
  • If applicable, ensure that the data source server is configured for incoming connections.
  • Ensure that your user mapping settings for the REMOTE_AUTHID and REMOTE_PASSWORD options are valid for the connections to the data source. Alter the user mapping, or create another user mapping as necessary.
  • Check your server definition. If necessary, drop the server definition and create it again.