title: Block remote connection on SQL server and allow only local connection
body: <p>I am seeing multiple failed login attempts in my SQL server logs in production. I believe someone is trying to login using the "sa" credentials. I have disabled "sa" login. My SQL server is on the internet (public IP), I want to create a firewall rule which will allow only local connections i.e. my APP server on LAN.</p>
  
  <p>I opened up windows firewall and added a inbound rule which says that allow connection on port 1433 only from a particular IP address (my app server ip) and don't allow remote connections.</p>
  
  <p>But now, my app server is only not able to connect to sql server. </p>
  
  <p>Any ideas?</p>