Integration Services Console must pass through three layers of software components to contact a data source: Integration Server, ODBC, and the database client software. Failure within or between any of these components can cause a lack of communication between Integration Services Console and the data source.
In some cases, the error messages received in Integration Services Console may not contain sufficient information for you to diagnose and resolve the problem, and you must go to the Integration Server to get more information and find a resolution.
The three main categories of problems that break the lines of communication between Integration Services Console and the data source are:
The components of Integration Services or the data source are not installed or are installed on the wrong computer.
The components do not run because they are not set up properly.
The components are not compatible with the operating system.
The versions of the different components are not compatible with each other.
Configuration and communication problems:
The software components are not properly configured to communicate with each other.
User names, passwords, and permissions are configured or used inconsistently across the components and computers.
The communication interfaces of the software components are incompatible with each other.
Changes to components, databases, users, or permissions have put the software components out of sync with each other.
Network and security problems:
A physical network path does not exist between the computers that must communicate with each other.
One or both computers attempting to communicate do not have the TCP/IP network protocol installed or configured.
The computer attempting to contact another computer does not have access to addressing information, such as a domain name server (DNS).
Security systems prevent all communication or certain types of communication between the computers that must talk with each other. For example, this is the case when client and server computers are separated by a firewall.