| Author |
Does SQL server supports Cable Redundancy ?
|
|
| Anil Gopu 2005-11-30, 7:23 am |
| Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.
--
Thanks
AnilG
| |
| Mike Epprecht \(SQL MVP\) 2005-11-30, 7:23 am |
| Hi
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@microso
ft.com...
> Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> redundancy.
>
> --
> Thanks
> AnilG
| |
| Anil Gopu 2005-11-30, 7:23 am |
| 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 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@microso
ft.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@microso
ft.com...[color=darkred]
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
>
> --
> Thanks
> AnilG
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
| |
| Anil Gopu 2005-11-30, 7:23 am |
| Cable redundancy is working for Win 2003 server when applied a hotfix as
given in KB : http://support.microsoft.com/defaul...b;en-us;817690.
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 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@microso
ft.com...
>
>
>
|
|
|
|