Cannot connect to SQL Server when IP is > .100

Question

I have an MSSQL 2008 Server being connected to from Windows XP.

I can access my database through a vb.net program and the SQL server management studio when the DHCP server assigns a low ip address (i.e. 192.168.0.3 - 100). At 192.168.0.101 the program nor server manager can find the database.

All of the computers can see each other and I can ping the server and the server can ping my system.

Answer 1

This sounds like your SQL server has a firewall rule only permitting port 1433 access from 192.168.0.1-192.168.0.100. This would mean that ICMP traffic (ping) still works, because only a specific protocol is being filtered.

Check the firewall rule on the SQL server and expand its scope as nessesary.

Answer 2

Try assigning a computer that is not working a lower IP and see what happens. Also, temporarily turn off the 2008 firewall and see if you can connect. Check the event logs on both the client and server. Use a packet sniffer (wireshark) on a working and non-working computer to see what the differences are.