Re: Network question and SQL
From: Mike Hodgson (mwh_junk_at_hotmail.com)
Date: 12/20/04
- Next message: evan b: "Re: Suggestions for managing large tables"
- Previous message: Ken Schaefer: "Re: Cached Logon"
- In reply to: John Bell: "Re: Network question and SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Dec 2004 11:05:38 +1100
Another thing to bear in mind is if you reference your SQL servers from
inside any DMZs. All decent firewalls these days refer to specific host
addresses, so if your SQL server does happen to get a new IP address
from a DHCP server then your firewall rules to that server will stop
working and your DMZ servers referencing your internal SQL boxes will break.
I can't really think of any particularly good reasons to allocate IP
addresses to servers via DHCP on an internal LAN. I'd say the cons
(increased reliance on DHCP servers, DNS servers, firewall rules, etc),
as John implied, far outweigh the pros (are there really any pros?).
All my SQL servers will always have static addresses if I have any say
in it (which I currently do).
Cheers,
Mike
John Bell wrote:
> Hi
>
> Alot of places have permanently allocated IP addresses for all their servers
> either "hard coded" (excluded) or reserved through DHCP. As your server
> should be up most of the time it will not be relinquishing the IP address
> therefore the main thing DHCP will give you is management (you will know all
> IP addresses are listed there) and the automatic updating of the DNS
> (assuming this is switched on). If you start having printers or other
> devices that are not DHCP capable, then this starts to fall down.
>
> Other things to consider would be the number of subnets that are being
> managed and the potential increase in the importance of the DHCP server. You
> will have to make sure that you don't loose information held on your DHCP
> server if it goes down, this will not be as important if it was only being
> used to deliver transient IP addresses. It may also increase your recovery
> time in case of failure.
>
> John
>
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:uSt9XjY5EHA.1760@TK2MSFTNGP10.phx.gbl...
>
>>We are looking at implementing a new network at another customer site and
>>the customer wants to use DHCP for all his SQL Servers.
>>I am aware that permanent IP addresses are good . Can someone give me the
>>pros and cons of whats ideal and why ? Links to any supporting documents
>>would be helpful
>>
>>
>>
>
>
>
- Next message: evan b: "Re: Suggestions for managing large tables"
- Previous message: Ken Schaefer: "Re: Cached Logon"
- In reply to: John Bell: "Re: Network question and SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
