[00:00] In this lesson, I'll connect an Azure SQL Database to Cloud Edition installed on an Azure VM. To create the database itself, I'm in the SQL Databases section of the SQL Azure service, and I'll start by clicking Create. This will take me to a form where I can fill out the configuration options for my database. Starting with the Basics tab, I'll need to fill out some project details. The subscription field is already filled out, but I'll need to select a resource group, so I'll add it to the group that I created while making my Azure VM with Cloud Edition. Next, I can start configuring the database details. 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 in 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 the one I chose for my VM. To access the server, I can use Microsoft and/or SQL authentication.

[01:04] I'm just going to use SQL authentication, so I'll specify a username and password, and then I'll click OK. Now my server's created, and if I want to modify the resources for my database, I can click Configure database here. I'll click Next to go into the Networking tab, 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'll make sure this is in the same location that I chose earlier, and then I'll provide a name. If it's in the same resource group, 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 OK. Next, I can click Review and create to see all the configuration options that are currently selected for the database.

[02:02] If you need to make any changes to these options, you can navigate to the corresponding section at the top of the page and make your selections there. I'm happy with my selections, so I'll click Create. This process might take a minute, so I'll cut forward to mine being done. Once that's deployed, my database should be accessible. I'll click Go to resource to see the details, and then I'll copy the server name to my clipboard, and then head over to my gateway webpage, and I'll create my database connection. I'll select the Microsoft SQLServer driver, and I'll give this connection a name. Then, I'll enter the username for my Azure credentials, which was "ignition", and I'll provide my embedded password. For the connect URL, I'm going to delete the default host and instance name 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. Finally, I'll want to change the database name in the extra connection properties, and then I'll click Create database connection.

[03:12] Now I have a valid connection to an Azure SQL Database from my Azure Cloud Edition installation.