Data Exposed | SQL Database Connectivity Explained

Play Data Exposed | SQL Database Connectivity Explained
Sign in to queue

Description

This session explains the basics of how connectivity works for SQL Database and how you can use network access controls to securely access SQL Database.

Note: At 7:33 during the video, it is said that "Allow Access to Azure services" restricts traffic to resources within the subscription - which is incorrect. Setting Allow access to Azure services button on the Portal (Firewall settings page) to ON shall allow traffic to/from resources ( e.g. Azure VM) or PaaS services( e.g. Web App) hosted inside Azure - within same subscription or from another subscription.

Read more at the following links:

Tag:

SQL Azure

Embed

Download

The Discussion

  • User profile image
    Ymer

    In the video, after discussing the option "Allow access to Azure services" around 7:32 there is a statement that it will only allow "..any service within your own subscription".
    Reading one of the issues on the the GitHub repo of "Use virtual network service endpoints and rules for database servers" https://github.com/MicrosoftDocs/azure-docs/issues/20809, one of the replies state that "..enabling this feature would allow any traffic from resources/services hosted in Azure (not just your Azure subscription) to access the database.".
    I'm a bit confused now, what statement is true or am I misinterpreting something?

  • User profile image
    dutchdatadu​de
    @Ymer: Setting Allow access to Azure services button on the Portal (Firewall settings page) to ON shall allow traffic to/from resources ( e.g. Azure VM) or PaaS services( e.g. Web App) hosted inside Azure - within same subscription or from another subscription as well. Hope this helps.
  • User profile image
    asgar

    Configure Azure SQL server as "Allow Access to Azure services" = OFF. Now i want to Azure data factory to connect to azure SQL server. Is it possible. Please provide your suggestions and comments.

Add Your 2 Cents