Hello, I'm trying to get DNN up and running on Azure. The site was built locally and with my Azure account, I created an App Service. The DNN website files were uploaded to Azure. I also have a SQL Server instance on Azure. I am getting this error in the DNN log file:
2019-11-01 00:04:16.629+00:00 [RD00155D7DD486][D:2][T:7][ERROR] DotNetNuke.Common.Initialize - The connection to the database has failed, however, the application is already completely installed, a 500 error page will be shown to visitors
In Azure, I have granted the App Service rights to the SQL Server database in the firewall settings (adding the IP of the App Service under Firewall rules).
I also changed the web.config connectionStrings/SiteSqlServer node to point to the Azure SQL Server. I am able to connect to the Azure SQL server successfully with the same credentials I have in the web.config file.
Is there anyone out there that has been able to get DNN running as an App Service in Azure? If so, any ideas what I may be missing?