sql 2005 cluster setup questions

#1

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?

#2

Answers
1) You have to install SSIS on each node, it is not cluster aware.
2) It doesn't matter but it is recomended to run setup from home node of
each instance.
3) Microsoft SQL Server 2005 Standard Edition supports up to two nodes in a
failover cluster. But if you are planning to have 2 instances on Node A and
2 instances on Node B that can fail to each other, the answer yes, it should
work.

Ayad Shammout

"Ellie" <Ellie (AT) discussions (DOT) microsoft.com> wrote

Quote:

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?

#3

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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?

#4

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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 active-active with
SQL 2005 Standatrd edition?

#5

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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 active-active
with
SQL 2005 Standatrd edition?

#6

"Geoff N. Hiten" wrote:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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 active-active
with
SQL 2005 Standatrd edition?

#7

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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 active-active
with
SQL 2005 Standatrd edition?

#8

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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
active-active
with
SQL 2005 Standatrd edition?

#9

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:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:402FF650-45D5-4D0D-89F8-48ABF1459A77 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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
active-active
with
SQL 2005 Standatrd edition?

#10

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:402FF650-45D5-4D0D-89F8-48ABF1459A77 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9 (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:1E2D18C0-A138-4823-B68E-C023E7505A1E (AT) microsoft (DOT) 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
active-active
with
SQL 2005 Standatrd edition?