Re: sql 2005 cluster setup questions

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

Listen to Geoff, always listen to Geoff. No matter what I ever say, listen to Geoff! And no I am not kidding, he is a God among men!

Cheers,

Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:48D3AC04-1297-4D98-ABF8-3888E50AFCCB@xxxxxxxxxxxxxxxx
Thanks again, Rodney. One more question, I don't need to do anything after
installing SSIS on 2nd node, right? Since I don't want them to be configured
as cluster resource?



"Rodney R. Fournier [MVP]" wrote:

Install the workstation stuff too!!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E3D34BB8-0A99-4FF4-AEDD-3CDEB725BC8F@xxxxxxxxxxxxxxxx
> Thanks, Rodney. I'll install SSIS on 2nd node. How about work > station
> component? I did not install it on the 2nd node in another cluster
> environment and don't plan to do it for this one either. will that be
> bad?
>
> "Rodney R. Fournier [MVP]" wrote:
>
>> Every node of a cluster should be alike in every way.
>>
>> Cheers,
>>
>> Rodney R. Fournier
>>
>> MVP - Windows Server - Clustering
>> http://www.nw-america.com - Clustering Website
>> http://msmvps.com/clustering - Blog
>> http://www.clusterhelp.com - Cluster Training
>> ClusterHelp.com is a Microsoft Certified Gold Partner
>>
>>
>> "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: New to clustering and need some clarification on disk resource
    ... "Geoff N. Hiten" wrote: ... second node, only the primary, during a cluster install. ... Senior SQL Infrastructure Consultant ... enough disk space for all your data. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Setting up Server Cluster for SQL Server - 2 Servers and a NAS
    ... I agree 100% with Geoff. ... things you can do with windows and an app like SQL Server on top of it. ... Trying to cluster with equipment that is not on the clustering HCL is just ... > As for your hardware, you don't have the pieces for a cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding a node to MS Clustering
    ... "Geoff N. Hiten" wrote: ... the cluster group, that is probably the basis of your problem. ... Principal SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... "Geoff N. Hiten" wrote: ... Senior SQL Infrastructure Consultant ... workstation tool on the second node of the PRODUCTION cluster. ... install SSIS, do you expect to see any issues? ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... we are on single instance cluster and will stay that way. ... "Geoff N. Hiten" wrote: ... Senior SQL Infrastructure Consultant ... Do I need to install it on Passive node too if I don't need ...
    (microsoft.public.sqlserver.clustering)