Azure Classroom Series – 07/Jan/2021

Endpoints in Azure SQL Databases

Private Endpoint in Azure SQL Database

  • Lets create a virtual network (192.168.0.0/16) with 3 subnets
    • web subnet (192.168.0.0/24)
    • app subnet (192.168.1.0/24)
    • db subnet (192.168.2.0/24)
  • Steps:
    • Create a virtual network Preview Preview Preview Preview Preview Preview Preview Preview Preview
    • Our network can be represented as shown below Preview
    • Now create a new resource group and add a sql server with database and navigate to the networking section Preview Preview Preview Preview Preview Preview Preview Preview Preview
    • Now lets look at endpoint Preview Preview
    • To test the private connectivity, lets create a windows server in app subnet Preview
    • Now login into the windows server and install client software for connecting to db
    • Lets install chocolatey for software installations Preview
    • As of now we are unable to establish connection from app subnet to Azure SQL over private connectivity Preview
    • Lets troubleshoot this in the next class.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About learningthoughtsadmin