Does SQL server supports Cable Redundancy ?

Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.
Thanks
AnilGHi
As long as both are connected to different segments, yes. That is a windows
limitation.
SQL server will listen on all NICs by default so it does not care. The Os
provides the functionality. The bigger challenge is to get your DNS to
change quick enough otherwise some users will hit the dead IP.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> redundancy.
> --
> Thanks
> AnilG|||Can I know what is meant by different segements. I am basically a VC++
programmer.
Thanks
AnilG
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> As long as both are connected to different segments, yes. That is a window
s
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>
>|||Hi,
Segments are networks or part of. You might have one segment with a
192.168.1 ip address and the other with 192.168.2 ip address. If you have
two network card in a machine they can be connected to two network segments.
The issue you raised is a Windows issue and depends on how you setup the
cards
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...[vbcol=seagreen]
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
> --
> Thanks
> AnilG
>
> "Mike Epprecht (SQL MVP)" wrote:
>|||Cable redundancy is working for Win 2003 server when applied a hotfix as
given in KB : [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;817690.[/url
]
But we facing the same problem in Win XP SP2. Any clues.
--
Thanks
AnilG
"GregO" wrote:

> Hi,
> Segments are networks or part of. You might have one segment with a
> 192.168.1 ip address and the other with 192.168.2 ip address. If you have
> two network card in a machine they can be connected to two network segment
s.
> The issue you raised is a Windows issue and depends on how you setup the
> cards
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the first and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...
>
>|||I am also having this same problem. How do you get the DNS to change quick
enough, so that the SQL db Admin's don't call me everytime they can not
connect? I have unchecked the "register this connections address in DNS" an
d
it still registers the address in DNS. The server that I am having problems
with is also a DNS server. Any suggestions?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> As long as both are connected to different segments, yes. That is a window
s
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>
>sql