When you configure it statically, can you ping the DNS server? Can you ping the workstation from the server? Did you put the IP of the DNS server in the client?
Don’t take this wrong, (I’ve seen experienced people mess this up), is the scope in the same subnet as the IP of the DHCP server?
You need to find out if this is a network issue or a configuration issue. The ping should answer that question.