In correcting connection problems with Integration Services, consider both component-level and system-level problems. The following topics list possible problems and areas for investigation within the software components of an Integration Services system.
To correct system-level problems that can occur across software components, review the following issues:
Are all user names and passwords being used consistently across all the components and computer user accounts? See User Name and Password Problems.
Do all user accounts used in the system have the appropriate permissions and privileges?
System administrators typically use highly privileged administrative accounts when setting up and testing a system. After the system is set up, users with fewer privileges may be unable to use the system successfully. Check permissions on the following components:
Are the software components using adequate addressing to identify the computers to which they are connecting?
Depending on the size and configuration of the computer network, it may be necessary to use a fully-qualified host address to connect to a particular computer. For example, instead of the host name “cypress,” the complete host name “cypress.mydivision.mycompany.com” may be required. Alternatively, you might need to use the IP address number for the server computer; for example, 127.0.0.1.
Is the user who starts Integration Server (for example, hyperion) configured to run all the required software?
The user (for example, hyperion) must have all required environment variables set and must have permissions to run all the following software components: