In SQL Server 2005 and SQL Server 2008, I know that you can install multiple instances of some services/subsystems. Does anyone have a good list of what is available for each version?
Of the four Server Components, only SSIS is "single-instance". The database engine, SSAS and SSRS can have multiple instances.
Suppose you have two instances of all components of SQL Server 2008, you will still only have one copy of SSIS. You can configure which instance's msdb is reflected when you connect SSMS to Integration Services through the file MsDtsSrvr.ini.xml
Management tools, including SQL Browser, are per-server.
It's also worth noting that SSIS 2008 cannot live beside SSIS 2005, although it will run SSIS 2005 packages as if it were SSIS 2005, as the run-time executables are versioned. If you have a SQL 2005 instance and a SQL 2008 instance, then SSIS is actually 2008, but is fully compatible with 2005.
answered Oct 21, 2009 at 10:33 PM