If you modify data source properties, refresh the data source before you test it.
Expand the Data Sources folder.
Highlight the data source, right-click, and select Refresh.
Refreshing a data source may affect running components that are using the data source, specifically:
If you change the connectivity library setting, data source references held by components become invalid. Attempts to retrieve connections or query data source properties cause errors. In this case, the component must retrieve a new data source handle.
If you change other properties, such as user name, password, server name, or the number of connections in a data source, data source references remain valid, but components may be affected by the changed settings. For example, if you change the server name, connections retrieved after the data source has been refreshed go to the server indicated by the new name.
Expand the Data Sources folder.
Highlight the data source, right-click, and select Ping.
A message box notifies you if ping is successful.