I am confused on how the Windows Server 2008 Firewall handles it's exclusions. I am trying to limit access to the SQL server to specific IP addresses: 188.8.131.52,184.108.40.206,127.0.0.1. I may not need the 127.0.0.1, but it's in there.
Connecting from localhost or 220.127.116.11 works fine. However, we have a website on another server which when I ping the website it goes to 18.104.22.168 (implying this is the IP address of the website I should use in the Firewall exception). When I try to access the application on this website that accesses the SQL server, I get an error that it cannot connect to the SQL server. I am not sure how to trace the connections and determine what is happening. If I allow any computer in the firewall exception, then it works fine from the website.
Suggestions? Do I have an incorrect assumption in confirming the IP address?