title: Azure Function App not able to access Azure SQL server- saying Client IP need to be added in SQL Server
body: <p>Getting below exception when my Azure Function App tries to connect with Azure SQL Server.</p>
  
  <pre><code>Cannot open server 'my-sql-sever' requested by the login. Client with IP address '52.165.228.212' is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.
  </code></pre>
  
  <p>Getting below exception when my Azure Function App tries to connect with Azure SQL Server.</p>
  
  <p>Cannot open server 'my-sql-sever' requested by the login. Client with IP address '52.165.228.212' is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.
  I was in impression that by default all Azure IPs of SQL database are whitelisted to Azure Fuction.</p>
  
  <p>Please suggest.</p>
  
  <p>Thanks, 
  Siraj</p>