I know I sound like a broken record, but can you give more detail as to the network and server, active directory/domain or a different setup. Most server's DHCP servers can give out IPs and reserve them so you get the best of both worlds. Can you routers do reservations? Of course, the SQL machine should be static, although that can be with a reservation also. Are you connecting to the sever with name or IP?
