You are here:

Troubleshooting A Failed Connection

Each DTS stores connection parameters for the source and any targets, which can include the data source name, server name, database name, user name, and password. This information is used to establish connections to the Source and Target when opening a DTS or running a job.

If any connection parameters stored in the DTS are invalid when you open the DTS file, the connection fails and an error message appears. You can often correct the problem using the information displayed by the failed connection's error messages.

To troubleshoot errors

In the Database Error window, click Details.
Click Next.
The text in the Description area helps you determine the cause of the connection error:
- Invalid data source name(s) — The message text typically includes a reference to a database or data source name.
- Invalid login parameters — The message text typically includes a reference to login, logon, or connection parameters.
To continue troubleshooting, click the link above that most closely matches the message displayed on your system.
Note: The specific message text in the Database Error window depends on the type of error, the database you are trying to connect to, and the database driver being used.