Why and when to perform this task
Many test connection problems can be easily fixed by verifying some configuration parameters This article provides a checklist of steps that you must complete to enable a successful connection. Click on the link for more information on a specific step.If your connection is still not successful after completing these steps and reviewing the applicable information, check the SYSOUT of your application servant region for warning or exception messages.
Steps for this task
If you are running Websphere Application Server Version 5.0.2, you do not have to complete this step unless you also created a new Java Authentication and Authorization Service (JAAS) entry.
You can test your connection from the data source collection view or the data source details view. Access either view in the administrative console, and then select a connection from the list. Click the test connection button on the connection.
You must complete all the steps and restart the server before you test the connection. Neither the authentication data alias nor the WebSphere Application Server environment variables (in Version 5.0.1) are available before a server restart.