I have a website up and running on Umbraco Cloud. This website needs to do some background processing and therefore I make the use of Hangfire (https://www.hangfire.io/).
In my case Hangfire needs a SQL database to properly function.
Microsoft Azure was already used to host and store other resources that are needed for the application so it's logical to add a SQL database there and use that one.
For local development I got everything up and running. Of course I needed to add my office's IP address to the Azure SQL server firewall IP whitelist.
Currently the Umbraco Cloud development (and also live) cannot connect to that database because its IP address is not whitelisted.
Any idea how I can get those and if they are statical?
Azure SQL server whitelisting
Hello,
I have a website up and running on Umbraco Cloud. This website needs to do some background processing and therefore I make the use of Hangfire (https://www.hangfire.io/).
In my case Hangfire needs a SQL database to properly function. Microsoft Azure was already used to host and store other resources that are needed for the application so it's logical to add a SQL database there and use that one.
For local development I got everything up and running. Of course I needed to add my office's IP address to the Azure SQL server firewall IP whitelist.
Currently the Umbraco Cloud development (and also live) cannot connect to that database because its IP address is not whitelisted.
Any idea how I can get those and if they are statical?
Best regards,
Simran Singh
Hi Simran,
If you go to your project on Umbraco Cloud via the http://umbraco.io and then go to the settings section. https://our.umbraco.org/documentation/Umbraco-Cloud/Set-up/project-settings/#project-settings
And the go to the connections details then you can white list your IP for the firewall - https://our.umbraco.org/documentation/Umbraco-Cloud/Databases/#opening-the-firewall
Hope this helps,
/Dennis
is working on a reply...