To correct problems connecting to the data source, investigate the following possible causes:
Is the data source server computer and software running? Has the server locked up, stopped, or failed?
Is the data source software installed? Are all components required for ODBC connections installed?
Some data sources may require additional software components beyond the basic server software to enable ODBC connections. The database client software is usually required on the computer that connects to the data source server using ODBC and also may be required on the data source server computer.
Do the OLAP Metadata Catalog and data source databases to which you are trying to connect exist? Have the tables for OLAP Metadata Catalog been created?
You can create the OLAP Metadata Catalog tables either automatically or by using the creation scripts provided with Integration Services. See Creating, Upgrading, and Deleting OLAP Metadata Catalogs.
What are the exact names of the OLAP Metadata Catalog and data source databases? Are the names case-sensitive?
Does the user name that you are using to connect to the data source have adequate permissions to access the database? Does the user have read and write permissions?
For the OLAP Metadata Catalog database, users need full read and write permissions. For the data source database, users need read-only permissions.
If the data source server is on a computer by itself, is there a corresponding user account on the computer for the user names you are using to connect to the databases?
To allow connections to the database server from other computers, you may need to set up user accounts on the data source server computer, separate from the database users you create.
Does the data source require any addressing beyond the name of the database if you are using the database client software or ODBC to connect?
Some data sources may have specific naming requirements for connecting to their databases, including different naming conventions for third-party applications (such as Integration Services). See the documentation for the data source.