"Li" <Li@discussions.microsoft.com> wrote in message
news:54E914C4-8FCC-497E-91DE-64EED9064D04@microsoft.com...
>I got an error hoping someone can help me:
>
> When I run the installation, I missed a '\' when specified destination
> folder name for the work station component, it looks hideous in NT
> Explorer
> so I decided to uninstall work station (it was only installed on primary
> node
> at this point) component, deleted the folder from both nodes then
> reinstall
> it with correct folder name. Everything went smoothly, new installation
> completed with correct folder name and tools are working fine. When I
> went
> to 2nd node to install work station component, the original folder was
> still
> there and would not let me delete saying "Cannot delete
> DTSPipelinePerf.dll:Access is denied..." SSIS was installed on the
> primary
> node at the time so I unintalled it to make sure nothing was using the
> .ddl
> but still getting the same error after reboot both nodes. The worst part
> is,
> if I try to install work station on 2nd node, it will point to there and
> would not let me change the installation path. I only have Database
> Engine
> installed right now, no components. I asked my NT Admin to force delete
> the
> folder but he said "I can remove the reference to the DLL from the
> Registry
> so it won't load...". Does anyone has any suggestions? I prefer not
> touching registry keys. Thanks in advance for your help.
>
> "Geoff N. Hiten" wrote:
>
>> Glad I could help.
>>
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>> "Li" <Li@discussions.microsoft.com> wrote in message
>> news:6DB00AC3-DD73-47B4-AF81-6FDA887F684B@microsoft.com...
>> > 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@discussions.microsoft.com> wrote in message
>> >> news:402FF650-45D5-4D0D-89F8-48ABF1459A77@microsoft.com...
>> >> >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@discussions.microsoft.com> wrote in message
>> >> >> news:F87915F6-4B88-44D8-92CB-2758872CC0B9@microsoft.com...
>> >> >> > 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@discussions.microsoft.com> wrote in message
>> >> >> >> news:1E2D18C0-A138-4823-B68E-C023E7505A1E@microsoft.com...
>> >> >> >> > 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