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