If you have problems connecting to OLAP Metadata Catalog or to the external data source with Integration Services Console, review the following list of common problems for specific databases:
IBM DB2: You may be required to bind the database driver to a IBM DB2 server that is managing the databases you want. See the IBM DB2 installation documentation.
Microsoft SQL Server: If you try to access a Microsoft SQL Server database with the Microsoft-supplied ODBC driver when you do not have access permission, SQL Server connects you to the default database and does not notify you. Configure the ODBC DSN to use the database that you want to access. See the Microsoft SQL Server documentation.
If none of the previous suggestions help, proceed to ODBC and Connection Problems for an overview of connection problems, then see Isolating Connection Problems.