The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL

Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS &amp; DTS services on their server. They are still on process of assessing the move from SQL Server 2000 to 2005 version, for the development purpose the test server has been setup with SQL Server 2000 as default instance and SQL Server 2005 as named instance. The...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/03/03/the-sql-server-specified-in-ssis-service-configuration-is-not-present-or-is-not-available-this-might-occur-where-there-is-no-default-instance-of-sql-server-on-the-computer.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3640" width="1" height="1">