How To Update Connection Policy Of Synapse Dedicated SQL Pools

SOLVED - How To Update Connection Policy Of Synapse Dedicated SQL Pools

The enterprise data warehousing features in Azure Synapse Analytics are called Dedicated SQL pools (formerly SQL DW). They represent a collection of analytic resources that are provisioned when using Synapse SQL. While these are pretty useful, quite often you can run into policy issues.

SOLVED - How To Update Connection Policy Of Synapse Dedicated SQL Pools

Ideally, you can easily change/ update the connection policy for Synapse dedicated SQL pools of Azure Synapse. However, sometimes the “Networking” tab of Azure Synapse only allows you to change Firewall rules. While you can add client IP addresses or allow Azure services/resources to access the workspace, you may not be able to change the connection policy. Additionally, you might not see the “Networking” tab itself in the dedicated SQL pool resource.

You May Also Like: Do I need To Install Antivirus Software On My PC, Tablet And Smartphone? Lets Find Out!

Here’s How To Change Connection Policy Of Synapse Dedicated SQL Pools

Make sure that you are looking in the right place. For example, the settings for the Azure SQL Logical Server are not applicable to Azure Synapse Analytics’ dedicated SQL pool. The Azure Synapse Analytics dedicated SQL pool is different from Azure Synapse Dedicated SQL Pools (formerly SQL DW).

SOLVED - How To Update Connection Policy Of Synapse Dedicated SQL Pools
SOLVED - How To Update Connection Policy Of Synapse Dedicated SQL Pools

The Azure Synapse Dedicated SQL Pools (formerly SQL DW) are on the Azure SQL logical server. For Azure Synapse Analytics workspaces, you can check the Connectivity Settings here.

SOLVED - How To Update Connection Policy Of Synapse Dedicated SQL Pools

PLEASE NOTE: The connection policy is applicable only on the Synapse Workspace level via the “Networking” tab. You can’t update the connection policy of “Dedicated SQL endpoint”.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *