How make [Web Forms for Marketers] module works when using Sitecore Azure?

Question

Recently, i am working on a project using Sitecore Azure. when creating a web form, we use Web Forms for Marketers module provided by Sitecore. It works fine in local environment. but when we publish it to Azure. it dose not work. Because there is no database for web form in Azure. Has anyone experienced this before, maybe you guys can help me. Thanks

Answer 1

Finally, i get it down.

first, you need to create a same database for WFFM as the local one Sitecore_WebForms in SQL Azure. Here is a link tells you how to do it.

second, change the connection string in forms.config to point to the database in sql azure. here is a example.

<formsDataProvider type="Sitecore.Forms.Data.DataProviders.WFMDataProvider,Sitecore.Forms.Core">
  <param desc="connection string">Database=Sitecore_WebForms;Data Source=tcp:YOURSERVERNAME.database.windows.net,1433;user id=YOURID;password=YOURPASSWORD;Connect Timeout=60</param>
</formsDataProvider>

This is how i fix it. Hope it helps if anyone has the same problem.

Answer 2

Only Web Forms for Marketers (WFFM) 2.4 or higher is compatible with Sitecore Azure module. Additionally, you must use SQL Server version of WFFM database, which must be shared between all WebRole Instances. Please check the details here: https://kb.sitecore.net/articles/880886

How to add WFFM database in Sitecore Azure and automatically deploy it with entire Sitecore solution read in the following article: https://kb.sitecore.net/articles/179306

Best Wishes, Oleg