Testing a database connection

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:

  1. In the Data Source Explorer, right-click a database connection .
  2. 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.

Feedback