Azure SQL Databases
- Azure SQL is a fully managed SQL Server from Azure
- To Create Azure SQL Database, we need to create or choose existing Azure SQL Server.
- Connection Strings: To connect to databases from applications
- Private Endpoint: To connect to Azure VM’s in Azure VNets using private link
Activity 1:Create a Private connection between a virtual network and Azure sql Database
- Create a Resource Group
- Create a virtual Network
- Create an Azure SQL Database with private connection to db subnet
- Lets observe connection strings
- Lets try to create a windows server 2019 Azure VM in the app subnet
- To connect to windows server Execute
Run (Win+R)
mstsc -v <publicip>
- Now as we have done in the class we were able to connect from vm in the same vnet but not from other networks.
