You can test a database connection from the Data Source Explorer
view to ensure that the properties and user authorization for the connection
are valid.
To test a database connection:
- In the Data Source Explorer, right-click a database connection
.
- Select Ping. If user and
password information is not already saved, you are prompted to enter your
user ID and password in the Properties window.
If the connection test is successful, a message opens indicating
a successful connection. If the connection is not successful, you see an error
message. Click
Details in the error message for more
information. If the connection is not successful, you can try the following
common fixes:
- Ensure that the database server is running.
- Ensure that you have entered a valid user ID and password.
- Edit the connection properties if
necessary. In particular, verify that the path to the JAR files that implement
the driver are correct. This is especially important if you are migrating
to this product from a previous release.
- Ensure that you have resolved any firewall issues.