What SQL Server subsystems are instance aware?

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?

more ▼

asked Oct 21, 2009 at 08:42 PM in Default

avatar image

Steve Jones - Editor ♦♦
5.2k 79 94 87

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 21, 2009 at 10:33 PM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 21, 2009 at 08:42 PM

Seen: 3324 times

Last Updated: Oct 22, 2009 at 06:47 AM

Copyright 2018 Redgate Software. Privacy Policy