Testing a database connection

You can test a database connection to ensure that the properties and user authorization for the connection are valid.

Procedure

To test a database connection:

  1. In the Data Source Explorer (or the Administration Explorer for products that include this view), 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.

Results

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.
  • Ensure that you have resolved any firewall issues.

Feedback