Re: sql 2005 cluster setup questions

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

My children seem to have a different opinion. :)

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


"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:848EE766-0AFD-47C3-9C77-B0FA86C0C526@xxxxxxxxxxxxxxxx
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: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
  • Re: Bad startup parameter on clustered instance
    ... you shouldn't directly edit the registry entries of a cluster-aware ... SQL Server resource to keep failing the startup. ... This is because the cluster service checkpoints its changes and basically ... Check the registry entries for the startup parameters on the node to make ...
    (microsoft.public.sqlserver.clustering)