After you have corrected problems with the components that enable Integration Services Console to connect to the data source, attempt a connection from the console to an OLAP Metadata Catalog and a database in the data source to prove the corrections are successful. To isolate possible computer-to-computer connection problems, run Integration Services Console on a different computer than the one running Integration Server.
To test the Integration Services Console connection to the data source:
Verify that Integration Server is running.
If Integration Server is not running, start it. If Integration Server will not start, check that the Integration Services environment variables are set. See Correcting Integration Server Problems.
On a computer other than the one running Integration Server, start Integration Services Console.
Connect to the Integration Server computer and OLAP Metadata Catalog; for example, cypress and TBC_MD.
If the connection fails, verify that you have specified the correct ODBC data source name for the OLAP Metadata Catalog database and the correct Integration Server computer name. Also verify that you specified the correct user name and password for the OLAP Metadata Catalog database on the data source. See Correcting Integration Services Console Problems.
After connecting to OLAP Metadata Catalog, open an OLAP model and connect to the data source for the OLAP model.
If the connection fails, verify that you have specified the correct ODBC data source name for the data source and the correct Integration Server computer name. Also verify that you specified the correct user name and password for the data source database on the data source. See Correcting Integration Services Console Problems.