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
  • Our network can be represented as shown below
  • Now create a new resource group and add a sql server with database and navigate to the networking section
  • Now lets look at endpoint
  • To test the private connectivity, lets create a windows server in app subnet
  • Now login into the windows server and install client software for connecting to db
    • SQL Server Managment Studio Refer Here
    • LinqPad
  • Lets install chocolatey for software installations
  • As of now we are unable to establish connection from app subnet to Azure SQL over private connectivity
  • Lets troubleshoot this in the next class.