title: Whitelist a login and IP Address in SQL Server
body: <p>I am wondering if there's a way to whitelist a SQL Server login for a particular IP address. More specifically I want to achieve the following:</p>
  
  <ol>
  <li>Any SQL Server logins, except login <code>SomeLogin</code>, can connect to the database server from any IP, and, </li>
  <li><code>SomeLogin</code> can connect to the database server only from a particular IP address</li>
  </ol>