Azure Front Door with Wildcard domains

 When setting up Azure Front Door with wildcard domain names, there are a few things that need to be taken care of to get everything working correctly. Here are some key steps -

1. Add your domain.
   
2. Create the Origin Group / Origin. When creating the Origin leave the Origin Host Header blank. If you have a Private Link to, say, a backend load balancer, then enable that as well.
   
   
   
   
3. In your Front Door Endpoint, add the route to your wildcard domain.
   
   
   
   
4. Since you would need to create a CNAME to point to the endpoint, use HTTP Forwarding from your DNS server (or DNS provider) for your naked domain to, say, www.whateveryourdomainis.com. Then create a CNAME for www to point to the Endpoint.
   
   
   
   
   If you have any questions, please reach out to blog@aileronconsulting.com. We are happy to assist.

blog@aileronconsulting.com

 

 

Azure SQL Iaas Agent Not Updating Data on Azure Portal

 On Azure Portal you can install "SQL Virtual Machine" resource to monitor your Windows Virtual Machines to automate management and administration tasks. Sometimes Azure Portal does not reflect the state of your VM and there would be no data displayed on the Azure Portal for the SQL VM resource. Your first option is to Force repair as shown below.

 

If that doesn't work you can try to run the following command from Azure CLI. Note that you will get a warning about sql_management_mode being deprecated but you can ignore it.

az sql vm create --name YOURSQLVMNAM --resource-group YOURRESOURCEGROUPNAME --location YOURRESOURCELOCATION --license-type payg --sql-mgmt-type Full

 

blog@aileronconsulting.com

 

Adding an existing database to Azure Elastic Pool - 'System' is not a valid database edition in this version of SQL Server. Error

 When adding an existing database to an Azure Elastic Pool you may encounter the "'System' is not a valid database edition in this version of SQL Server." error message. To address this issue, go to the "Compute + Storage" setting for your database and modify it to a "Standard" Service tier at a minimum.

blog@aileronconsulting.com