So Grasshopper,

What is your network configuration with SQL server and Server 2000?

Understood about DHCP and how it works and understand DNS in the form you mention, but that is where I fall flat on my face on a small network such...

PQ53,

Well originally, many of the systems were using 98SE/ME and some 2000, and NetBEUI is more secure than using NetBIOS over TCP/IP as file and printer sharing is bound to...

Ok great, that's starting to make better sense now.

So I don't necessarily have to lock it in with a mac address on the router, I can just assign the IP...

"if DNS-Server-IP is given and the appropriate checkbox in the "Advanced TCP/IP Settings" - "DNS" is activated (Register this connection's adresses in DNS)"

1.) So, this setting has to be on...

Well other PC's in the network regularly access on another on a regular basis to share files.

It is a mixed 2k, XP 98SE environment. I have been working to upgrade the PC's to at least 2k. There will only be one 98SE that will need to...

So DNS will work ok with DHCP.... hmm

That's where I fall short, perhaps some steps?

The router is doing DHCP...there is no domain.

This is where I fall short, I've googled quite...