Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

Connecting to Microsoft Azure Synapse SQL using an Azure private endpoint

Create an Azure private endpoint

Create an Azure private endpoint

Create an Azure private endpoint for secured connectivity between clients on your virtual network and your Microsoft Azure Synapse SQL account.
You can create a private endpoint for an existing or a new Microsoft Azure Synapse SQL account.

Create a private endpoint for a new Microsoft Azure Synapse SQL account

  1. In the search box, enter
    Dedicated SQL pools
    , and then select
    Dedicated SQL pools
    in the search results.
  2. On the
    Dedicated SQL pools
    page, click
    Create
    to create a new Microsoft Azure Synapse SQL account.
  3. On the
    Basics
    tab, enter the project and SQL pool details.
    1. In the
      Subscription
      field, select the subscription in which you want to create the account.
    2. In the
      Resource group
      field, select the resource group in which the Azure resources are deployed and managed.
    3. In the
      SQL pool name
      field, enter a name for the Microsoft Azure Synapse SQL account.
      The name must be unique in the server, must not exceed 60 characters in length, and must not contain reserved words.
    4. In the
      Server
      field, select an existing SQL server or create a new server.
  4. On the
    Networking
    tab, click
    Add private endpoint
    .
    1. In the
      Subscription
      field, select the subscription for which you want to create the private endpoint.
    2. In the
      Resource group
      field, select the resource group in which the Azure resources are deployed and managed.
    3. In the
      Location
      field, select the location.
      Ensure that the subscription, resource group, and location for the private endpoint are the same as that of the virtual network.
    4. Enter a name for the private endpoint.
    5. In the
      Target sub-resource
      field, select
      SqlServer
      .
    6. In the
      Networking
      section, select the virtual network and the subnet that you created.
    7. Click
      OK
  5. On the
    Review + Create
    tab, verify the details, and then click
    Create
    .

Create a private endpoint for an existing Microsoft Azure Synapse SQL account

  1. Navigate to the SQL server that contains the Microsoft Azure Synapse SQL account for which you want to create a private endpoint.
  2. Click
    Networking
    .
  3. On the
    Public access
    tab, select
    Selected networks
    .
  4. On the
    Private access
    tab, click
    Create a private endpoint
    .
  5. On the
    Basics
    tab, enter the project and instance details.
    1. In the
      Subscription
      field, select the subscription for which you want to create the private endpoint.
    2. In the
      Resource group
      field, select the resource group in which the Azure resources are deployed and managed.
    3. Enter a name for the private endpoint.
    4. In the
      Region
      field, select the location for the private endpoint.
      Ensure that the subscription, resource group, and location for the private endpoint are the same as that of the virtual network.
    5. Click
      Next : Resource
      .
  6. On the
    Resource
    tab, select the
    Target sub-resource
    as
    sqlServer
    and then click
    Next : Virtual Network
    .
  7. On the
    Virtual Network
    tab, select the virtual network and subnet that you created, and then click
    Next : Tags
    .
  8. Optional. On the
    Tags
    tab, create tags to categorize resources and view consolidated billing by applying the same tag to multiple resources and resource groups, and then click
    Next : Review + Create
    .
  9. On the
    Review + Create
    tab, verify the details, and then click
    Create
    .

0 COMMENTS

We’d like to hear from you!