KB : How to resolve "An error occurred accessing the database" for Azure Web App

For some reasons in Azure Portal settings, if a user installed the Synchronizer as an Azure Web App, it can occur the following error,

An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure

To resolve this, please check in Azure Portal settings for TFS4JIRA Web App if it's running on 32 bit or 64 bit. Synchronizer needs to run on 32 bit mode, and this error usually is shown when the Web App is running on 64 bit mode.

 If it's already at 32 bit. Please try the following,

1. Access the Azure portal.
2. Access the General Settings page for the TFS4JIRA Synchronizer application.
3. Change Platform settings to 64-bit.
4. Go to App Services and restart the TFS4JIRA Synchronizer app.
5. Change Platform settings back to 32-bit.
6. Go to App Services and restart the TFS4JIRA Synchronizer app.

By doing this, it should resolve the problem. We are still not sure why this problem occurs. We suspect it might be a bug in Azure Portal.