[00:00] In this lesson, I'll connect an Azure SQL database to Cloud Edition installed on an Azure VM. In the SQL Databases service in Azure, I'll click the Create button. The subscription field is already filled out, so I'll specify a resource group for this to live in, and I'm going to place it in my Cloud Edition resource group that I created while creating my VM. I'll give my database a name and it'll be important to remember this name as I'll be referring to it from the Database Connection and Ignition. Next, I'll need to make a server for my database, so I'll click create new. I'll give this a name, and I'm on the west coast of the US so I'll update my location to access the server. I can use Azure AD and or SQL authentication. I'm just going to use SQL authentication, so I'll specify a username and password, and then I'll click okay. Now my server is created, and if I wanna modify the resources for the database, I can click configure database here. I'll click next to go into networking.

[01:17] And if I want to access this database, I need to choose some sort of endpoint for my Azure apps. So I'm going to select a private endpoint, and then I can click the add private endpoint link here. I'm going to select the same location that my Cloud Edition VM is in, and then give this a name. I can add it to the same virtual network, and I'll pick the default subnet, and then I'll choose yes, integrate with Private DNS zone, and click Okay. Next, I can click review and create to see all the configuration options that are currently selected for the database. If you need to make changes to any of these options, you can navigate to the corresponding section at the top of the page and make your selections. Since I'm happy with my selections, I'll click create.

[02:19] Once that's deployed, my DB should be accessible. I'll click Go to Resource to see its details. And now I can copy the server name from the overview page, and I can go to my Gateway webpage to create a new database connection. I'll pick the Microsoft SQL Server driver, and I'll give this connection a name. I'm going to delete the default host and instance name from the Connect URL and paste my database server name I copied from Azure. I'll leave it at that and it'll connect to the default instance and port, which is perfect. Next, I'll enter the SQL authentication credentials I set up while creating the database, and then I'll wanna change the database name in the extra connection properties.

[03:20] And then I'll click create. And now I have a valid connection to an Azure SQL database from my Azure Cloud Edition installation.