Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Does SQL server supports Cable Redundancy ?
Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.

--
Thanks
AnilG

Report this thread to moderator Post Follow-up to this message
Old Post
Anil Gopu
11-30-05 12:23 PM


Re: Does SQL server supports Cable Redundancy ?
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



Report this thread to moderator Post Follow-up to this message
Old Post
Mike Epprecht \(SQL MVP\)
11-30-05 12:23 PM


Re: Does SQL server supports Cable Redundancy ?
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@microso
ft.com... 
>
>
>

Report this thread to moderator Post Follow-up to this message
Old Post
Anil Gopu
11-30-05 12:23 PM


Re: Does SQL server supports Cable Redundancy ?
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...
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
>
> --
> Thanks
> AnilG
>
>
> "Mike Epprecht (SQL MVP)" wrote:
> 



Report this thread to moderator Post Follow-up to this message
Old Post
GregO
11-30-05 12:23 PM


Re: Does SQL server supports Cable Redundancy ?
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@microso
ft.com... 
>
>
>

Report this thread to moderator Post Follow-up to this message
Old Post
Anil Gopu
11-30-05 12:23 PM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 11:25 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006