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

Why would you want to do that? NIC's are cheap. Like Rod said, you can't
team the heartbeat anyway.

As for the share, you can create a file share resource, set the permissions
and when the group fails over, the share goes with it.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"anoni" <anoni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62948B9C-E880-4196-9DD4-E5843C327087@xxxxxxxxxxxxxxxx
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/2005/07/20/58233.aspx NYC Clustering
> class
>
> "anoni" <anoni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:724C9799-49CB-462C-A4F4-D965EB27ACA2@xxxxxxxxxxxxxxxx
> >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.
> >
>
>
>

.

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to cluster instance from .NET
    ... I have tried using the SQL 2000 CD and i have ... Virtual IP addresses for the cluster resource groups. ... SQL Server will listen on only those IP addresses ... This is odd because the 172.16 network is a Class B ...
    (microsoft.public.sqlserver.clustering)
Loading