When you try to connect to SQL Server 2005 Integration Services (SSIS 2005) either using SQL Server Management Studio (SSMS) from SQL Server 2008 or SQL Server 2008 R2 you will experience one of the following error messages:
SQL Server 2008 RTM or Service Pack 1(SP1) versions:
SQL Server 2008 SP2 or later versions and SQL Server 2008 R2 or later versions:
SQL Server 2008 RTM or Service Pack 1(SP1) versions:
Hresult: 0xC00160AA
Integer: -1073651542
Symbolic constant: DTS_E_CONNECTTOSERVERFAILED
Error Text: Connect to SSIS Service on machine "servername" failed:Class not registered.".
Integer: -1073651542
Symbolic constant: DTS_E_CONNECTTOSERVERFAILED
Error Text: Connect to SSIS Service on machine "servername" failed:Class not registered.".
SQL Server 2008 SP2 or later versions and SQL Server 2008 R2 or later versions:
Hresult: 0xC00160AC
Integer: -1073651540
Symbolic constant: DTS_E_CONNECTTOSERVERFAILED_NOTREGISTERED
Error Text: Connecting to the Integration Services service on the computer "__" failed with the following error: "__".
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance..
Integer: -1073651540
Symbolic constant: DTS_E_CONNECTTOSERVERFAILED_NOTREGISTERED
Error Text: Connecting to the Integration Services service on the computer "__" failed with the following error: "__".
This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance..