Azure SQL Database connctivity

Ankush Gurjar 165 Reputation points
2024-04-30T05:18:55.9333333+00:00

Hi Team,

I have deployed azure SQL database service and I want to connect this database within the private network or office network, which configuration need to do from azure side. which IP need to whitelist from our office network?

Thanks in advance!

Azure SQL Database
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
526 questions
{count} votes

Accepted answer
  1. Oury Ba-MSFT 19,901 Reputation points Microsoft Employee
    2024-04-30T16:36:24.7033333+00:00

    Ankush Gurjar

    Thank you for reaching out.

    In addition to Umar's answer below. To connect your Azure SQL Database within a private network or office network, you can use Azure Private Endpoint. Tutorial: Connect to an Azure SQL server using an Azure Private Endpoint using the Azure portal.

    Whitelisting a public IP address involves adding it to the server firewall rules in the Azure portal, ensuring secure access to your Azure SQL Database from your office network. Azure SQL Database and Azure Synapse IP firewall rules.

    Regards,

    Oury


1 additional answer

Sort by: Most helpful
  1. Umar 150 Reputation points
    2024-04-30T05:28:57.8066667+00:00

    To connect your Azure SQL Database within a private network or office network, you'll want to set up Azure Private Link. This allows you to access Azure services (like SQL Database) privately from within your virtual network. Additionally, you'll need to whitelist the public IP address of your office network to allow access. Would you like more detailed steps on how to configure this?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.