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
In the search box, enter
Dedicated SQL pools
, and then select
Dedicated SQL pools
in the search results.
On the
Dedicated SQL pools
page, click
Create
to create a new Microsoft Azure Synapse SQL account.
On the
Basics
tab, enter the project and SQL pool details.
In the
Subscription
field, select the subscription in which you want to create the account.
In the
Resource group
field, select the resource group in which the Azure resources are deployed and managed.
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.
In the
Server
field, select an existing SQL server or create a new server.
On the
Networking
tab, click
Add private endpoint
.
In the
Subscription
field, select the subscription for which you want to create the private endpoint.
In the
Resource group
field, select the resource group in which the Azure resources are deployed and managed.
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.
Enter a name for the private endpoint.
In the
Target sub-resource
field, select
SqlServer
.
In the
Networking
section, select the virtual network and the subnet that you created.
Click
OK
On the
Review + Create
tab, verify the details, and then click
Create
.
Create a private endpoint for an existing Microsoft Azure Synapse SQL account
Navigate to the SQL server that contains the Microsoft Azure Synapse SQL account for which you want to create a private endpoint.
Click
Networking
.
On the
Public access
tab, select
Selected networks
.
On the
Private access
tab, click
Create a private endpoint
.
On the
Basics
tab, enter the project and instance details.
In the
Subscription
field, select the subscription for which you want to create the private endpoint.
In the
Resource group
field, select the resource group in which the Azure resources are deployed and managed.
Enter a name for the private endpoint.
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.
Click
Next : Resource
.
On the
Resource
tab, select the
Target sub-resource
as
sqlServer
and then click
Next : Virtual Network
.
On the
Virtual Network
tab, select the virtual network and subnet that you created, and then click
Next : Tags
.
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