So I have my Windows Firewall setup with an exception for Microsoft SQL Server over port 1433. I made sure that my SQL Server Browser service is always running, and I used SQL Server Configuration Manager to ensure that the TCP/IP protocol does not use dynamic ports and only listens on port 1433. At first it was working great when I tried to access the database remotely. But then it just stopped working. I noticed when I disabled the firewall on the host machine, the remote machine could access the database immediately. And then when I turned the firewall back on, it was still able to access the remote database for a short period then it would be denied access again. Does anyone know why this might be the case?