x

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 '09 at 08:42 PM in Default

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 76 79 82

(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 '09 at 10:33 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1933
x1816
x341

asked: Oct 21 '09 at 08:42 PM

Seen: 2300 times

Last Updated: Oct 22 '09 at 06:47 AM