dbTalk Databases Forums  

How can I install Integration Services on a functioning SQL2008cluster?

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss How can I install Integration Services on a functioning SQL2008cluster? in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Jon
 
Posts: n/a

Default Re: How can I install Integration Services on a functioning SQL2008cluster? - 12-12-2008 , 10:29 AM






Ok so it looks like the way to do it is as a new installation, just
selecting Integration Services, and it sorts itself out.

On 12 Dec, 16:04, Jon <j.l.robin... (AT) gmail (DOT) com> wrote:
Quote:
Hi Ruben,

Thanks for the reply, however I don't think you've read my question.

As I mentioned I don't want to cluster it - can you be more specific
about what you mean when you say "You should
install and start the service on each node." ? What is the procedure
for installing this? Like I said, the SQL installer is inviting me to
install a separate instance of SQL - is this the only way to do it?

Jon

On 12 Dec, 15:01, Rubén Garrigós <rgarri... (AT) solidq (DOT) com> wrote:

Hi Jon,

SSIS is not a clustered service so you can't add it this way. You should
install and start the service on each node. Anyway, you can configure SSIS
as a cluster resource but it is not recommended. For more info :http://msdn.microsoft.com/en-us/library/ms345193.aspx

Regards,

Ruben
Solid Quality Mentors

"Jon" <j.l.robin... (AT) gmail (DOT) com> wrote in message

news:305cdb09-358d-4cbb-bb22-004b78eba7cc (AT) 40g2000prx (DOT) googlegroups.com...

How can I install Integration Services on a functioning SQL2008
cluster?

I'm not bothered about it being a clustered resource, but in the SQL
setup app it will not allow me to add the Integration Services feature
to the existing instance. The only option it presents is to install a
new instance of SQL server and integration services along with it -
the implication here though is that the feature will not be available
to the clustered instance.

I have a fully functional SQL 2008 Standard clustered default
instance, and all I want to do is add Integration Services. This
platform is in production so I cannot re-install the clustered
instance, or even stop it.

Any advice appreciated.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.