Re: sql 2005 cluster setup questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

Glad I could help.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:6DB00AC3-DD73-47B4-AF81-6FDA887F684B@xxxxxxxxxxxxxxxx
not waht I want to hear but thank you very much for the information - I did
want to take Microsoft recommended approach not to cluster SSIS but I think
I'll follow your suggestion because we do have shared files.

"Geoff N. Hiten" wrote:

Funny you should ask. I just wrote a blog post on that topic:

http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not-to-Cluster-That-SSIS-the-Question.aspx


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:402FF650-45D5-4D0D-89F8-48ABF1459A77@xxxxxxxxxxxxxxxx
>I installed SSIS on Active node of SQL Server 2005 Std, Active/Passive
> Cluster. Do I need to install it on Passive node too if I don't need > SSIS
> to
> be configures as a cluster resource? What will be the disadvantages > for
> not
> having SSIS on 2nd node?
>
> Thanks.
>
> "Geoff N. Hiten" wrote:
>
>> The usual "It depends" answer applies.
>>
>> I have been putting SSIS in a separate resource group, but only on
>> single-instance clusters. I haven't experimented with clustering SSIS
>> for
>> multiple instances. I suggest unclustered for this many nodes, that >> way,
>> there is always a local copy for each instance to use. If you only >> use
>> SSIS
>> on one instance, then I would cluster around that instance.
>>
>> -- >> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Ellie" <Ellie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:F87915F6-4B88-44D8-92CB-2758872CC0B9@xxxxxxxxxxxxxxxx
>> > Thanks so much for valuable information.
>> >
>> > what will be the best for consolidated sql envitonment on >> > active/active
>> > cluster with 4 instances
>> >
>> > 1. to install it SSIS on all nodes to leave it unclustered
>> > 2. to configure SSIS in all sql resource groups (dont know if that
>> > possible
>> > at all)
>> > 3. to cluster SSIS in different cluster group
>> >
>> >
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> By default, SSIS only does a local install. You can install it on
>> >> each
>> >> node
>> >> and cluster it "by hand" afterwards. Here is the article on how to >> >> do
>> >> it:
>> >> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
>> >>
>> >> The installer should start from the node that currently owns the >> >> disk
>> >> resource you wish to use for that particular SQL instance.
>> >> Personally, I
>> >> prefer to run the installer on each node and install just the >> >> client
>> >> tools
>> >> and documentation. Those components are not cluster-aware and must >> >> be
>> >> installed on each node separately anyway. It is less confusing if >> >> you
>> >> get
>> >> them out of the way first.
>> >>
>> >> Standard Edition only supports 2-node clusters. It won't work on
>> >> clusters
>> >> with more than two nodes.
>> >>
>> >> -- >> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "Ellie" <Ellie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:1E2D18C0-A138-4823-B68E-C023E7505A1E@xxxxxxxxxxxxxxxx
>> >> > Im working on sql consolidation project and I am about to build
>> >> > multiinstance
>> >> > 2 node cluster.
>> >> > If I want Integration services installed should I manually >> >> > install
>> >> > on
>> >> > both
>> >> > nodes or thats something that will be installed automatically on
>> >> > both
>> >> > nodes (
>> >> > It is crutial to have IS installed)
>> >> >
>> >> > i want to 2 instances to live on node1 and 2 more on node 2 ( >> >> > i.e.
>> >> > active
>> >> > active cluster). Should I start sql set up on one node only or I
>> >> > have
>> >> > to
>> >> > run
>> >> > setup from home node of each instance?
>> >> >
>> >> > last one q - is it possible to build 4-instance cluster
>> >> > active-active
>> >> > with
>> >> > SQL 2005 Standatrd edition?
>> >>
>> >>
>>
>>



.

Relevant Pages

  • Re: sql 2005 cluster setup questions
    ... "Geoff N. Hiten" wrote: ... Senior SQL Infrastructure Consultant ... install" error) that's why DBMail and Maintenance Plan is not working. ... I just want to make sure it's OK to apply Build 3175 on Cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding SSIS to sql 2005 cluster
    ... You will need to install SSIS on each node of the cluster. ... Sorry I cant help with the command line, ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... installing SSIS on 2nd node, ... http://www.clusterhelp.com - Cluster Training ... Do I need to install it on Passive node too if I don't need ... Senior SQL Infrastructure Consultant ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... Since you asked nicely, Yes, you should be able to install any of the non-clustered components on a currently inactive node without affecting the cluster. ... I have one-instance two-node clustered SQL server 2005 sp1. ... doesn’t have SSIS and workstation tools installed. ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... I installed SSIS on Active node of SQL Server 2005 Std, ... Do I need to install it on Passive node too if I don't need SSIS to ... be configures as a cluster resource? ...
    (microsoft.public.sqlserver.clustering)