configure sql cluster with one NIC (two nic but teamed)

I like to configure sql cluster with one NIC (two nic but teamed) . Anyone
tried it? Does it works. I know MS does not support such configure.
Once cluster servers configured? Can I change the server names, and virtual
servers and sql virtual server name? Also the ip addresses? And add
resources as needed?
Thanks.
You can team the Public, you can't team the Private (Heartbeat network). We
team all our Public interfaces, works great (with the right version of the
nic drivers).
You can't rename a SQL instance (not fully support and will break SQL), but
you can change IPs within a cluster.
Why types of resources do you want to add?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:724C9799-49CB-462C-A4F4-D965EB27ACA2@.microsoft.com...
>I like to configure sql cluster with one NIC (two nic but teamed) . Anyone
> tried it? Does it works. I know MS does not support such configure.
> Once cluster servers configured? Can I change the server names, and
> virtual
> servers and sql virtual server name? Also the ip addresses? And add
> resources as needed?
> Thanks.
>
|||Check out:
http://www.microsoft.com/downloads/d...displaylang=en
Don't use teamed NIC's.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:724C9799-49CB-462C-A4F4-D965EB27ACA2@.microsoft.com...
I like to configure sql cluster with one NIC (two nic but teamed) . Anyone
tried it? Does it works. I know MS does not support such configure.
Once cluster servers configured? Can I change the server names, and virtual
servers and sql virtual server name? Also the ip addresses? And add
resources as needed?
Thanks.
|||Correction from the document:
If you are using fault-tolerant network cards or network adapter teaming, verify that you are using the most recent firmware and drivers. Check with your network adapter manufacturer for cluster compatibility.
Note: Microsoft does not recommended that you use any type of fault-tolerant adapter or "Teaming" for the heartbeat. If you require redundancy for your heartbeat connection, use multiple network adapters set to Internal Communication Only and define their network priority in the Cluster configuration. Issues seen with early multi-ported network adapters, verify that your firmware and driver are at the most current revision if you use this technology.
Contact your network adapter manufacturer for information about compatibility on a server cluster. For additional information, see the following article in the Microsoft Knowledge Base:
254101 Network Adapter Teaming and Server Clustering
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering class
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message news:uZk1$ryrFHA.2328@.TK2MSFTNGP10.phx.gbl...
> Check out:
> http://www.microsoft.com/downloads/d...displaylang=en
> Don't use teamed NIC's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:724C9799-49CB-462C-A4F4-D965EB27ACA2@.microsoft.com...
> I like to configure sql cluster with one NIC (two nic but teamed) . Anyone
> tried it? Does it works. I know MS does not support such configure.
> Once cluster servers configured? Can I change the server names, and virtual
> servers and sql virtual server name? Also the ip addresses? And add
> resources as needed?
> Thanks.
>
|||Thanx, Rod. What stuck in my mind was not to team vs. not to team the
heartbeat.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23iQ$C2yrFHA.332@.tk2msftngp13.phx.gbl...
Correction from the document:
If you are using fault-tolerant network cards or network adapter
teaming, verify that you are using the most recent firmware and drivers.
Check with your network adapter manufacturer for cluster compatibility.
Note: Microsoft does not recommended that you use any type of fault-tolerant
adapter or "Teaming" for the heartbeat. If you require redundancy for your
heartbeat connection, use multiple network adapters set to Internal
Communication Only and define their network priority in the Cluster
configuration. Issues seen with early multi-ported network adapters, verify
that your firmware and driver are at the most current revision if you use
this technology.
Contact your network adapter manufacturer for information about
compatibility on a server cluster. For additional information, see the
following article in the Microsoft Knowledge Base:
254101 Network Adapter Teaming and Server Clustering
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uZk1$ryrFHA.2328@.TK2MSFTNGP10.phx.gbl...
> Check out:
> http://www.microsoft.com/downloads/d...displaylang=en
> Don't use teamed NIC's.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:724C9799-49CB-462C-A4F4-D965EB27ACA2@.microsoft.com...
> I like to configure sql cluster with one NIC (two nic but teamed) . Anyone
> tried it? Does it works. I know MS does not support such configure.
> Once cluster servers configured? Can I change the server names, and
> virtual
> servers and sql virtual server name? Also the ip addresses? And add
> resources as needed?
> Thanks.
>
|||Can you use one teamed nic to serve both public and heartbeat role? A while
ago, a consultant did some like this in our company. It never work out the
way it should.
Also, can I fail over the a share folder permisson for windows 2003
clustered servers? Again, a cosultant did it with one teamed NIC to serve
both public and private heartbeat. and our shared folder permission never get
fail over when we take down the primary node.
Thanks.
"Rodney R. Fournier [MVP]" wrote:

> You can team the Public, you can't team the Private (Heartbeat network). We
> team all our Public interfaces, works great (with the right version of the
> nic drivers).
> You can't rename a SQL instance (not fully support and will break SQL), but
> you can change IPs within a cluster.
> Why types of resources do you want to add?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
> class
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:724C9799-49CB-462C-A4F4-D965EB27ACA2@.microsoft.com...
>
>
|||Answers below...
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:62948B9C-E880-4196-9DD4-E5843C327087@.microsoft.com...
> Can you use one teamed nic to serve both public and heartbeat role? A
> while
> ago, a consultant did some like this in our company. It never work out the
> way it should.
>
While you can setup the Public to be in mixed mode, it should not be your
primary heartbeat traffic. Use a dedicated private network for heartbeat
traffic.

> Also, can I fail over the a share folder permisson for windows 2003
> clustered servers? Again, a cosultant did it with one teamed NIC to serve
> both public and private heartbeat. and our shared folder permission never
> get
> fail over when we take down the primary node.
>
If you create the share as a resource within the cluster, it will failover
with the cluster. Never create it on the individual machines.
Sounds like your old consultant needed more clustering experience.
[vbcol=seagreen]
> Thanks.
> "Rodney R. Fournier [MVP]" wrote:
|||how big a volume should be created for cluster quorum?
Thanks.
"Rodney R. Fournier [MVP]" wrote:

> Answers below...
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:62948B9C-E880-4196-9DD4-E5843C327087@.microsoft.com...
> While you can setup the Public to be in mixed mode, it should not be your
> primary heartbeat traffic. Use a dedicated private network for heartbeat
> traffic.
>
> If you create the share as a resource within the cluster, it will failover
> with the cluster. Never create it on the individual machines.
> Sounds like your old consultant needed more clustering experience.
>
>
|||500MB - same for MSDTC.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"anoni" <anoni@.discussions.microsoft.com> wrote in message
news:3D9B9BBF-1B38-473C-A7CF-5D4E02CDEFAC@.microsoft.com...
how big a volume should be created for cluster quorum?
Thanks.
"Rodney R. Fournier [MVP]" wrote:

> Answers below...
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:62948B9C-E880-4196-9DD4-E5843C327087@.microsoft.com...
> While you can setup the Public to be in mixed mode, it should not be your
> primary heartbeat traffic. Use a dedicated private network for heartbeat
> traffic.
>
> If you create the share as a resource within the cluster, it will failover
> with the cluster. Never create it on the individual machines.
> Sounds like your old consultant needed more clustering experience.
>
>
|||Correct, but I like 1 GIG, its easy on my math skills
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23duC7p7rFHA.1172@.TK2MSFTNGP11.phx.gbl...
> 500MB - same for MSDTC.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "anoni" <anoni@.discussions.microsoft.com> wrote in message
> news:3D9B9BBF-1B38-473C-A7CF-5D4E02CDEFAC@.microsoft.com...
> how big a volume should be created for cluster quorum?
> Thanks.
> "Rodney R. Fournier [MVP]" wrote:
>