Connect to Azure using Point-to-Site VPN to Connect to Azure SQL Database
This past week a client of mine gave me a challenge:
Configure an environment that meets the following criteria
- Remove the need to manage IP addresses for SQL Azure
- Use a hub and spoke VNET configuration
- Connect to Azure using a VPN - using Azure Active Directory (AAD) authentication would be a bonus
- Connect to SQL Azure using AAD authentication
Originally, I thought this would be quick and simple … turns out it isn’t. After doing some searching online, I found many people trying to solve similiar challenges. Here are some recent posts I found in Microsoft Learn: