Event Recap – European Collab/Cloud/BizApps – Dusseldorf – May 2025
June 10, 2025Model Mondays Season 2: Learn to Choose & Use the Right AI Models with Azure AI
June 10, 2025
Logic Apps uses Azure Storage by default to hold workflows, states and runtime data. However, now in preview, you can use SQL storage instead of Azure Storage for your logic apps workflow related transactions.
Note that Azure Storage is still required and SQL is only an alternative for workflow transactions.
Why Use SQL Storage?
| Benefit | Description |
|---|---|
| Portability | SQL runs on VMs, PaaS, and containers—ideal for hybrid and multi-cloud setups. |
| Control | Fine-tune throughput and performance; predictable pricing based on usage. |
| Reuse Assets | Leverage SSMS, CLI, SDKs, and Azure Hybrid Benefits. |
| Compliance | Enterprise-grade backup, restore, failover, and redundancy options. |
When to Use SQL Storage
| Scenario | Recommended Storage |
|---|---|
| Need control over performance | SQL |
| On-premises workflows (Azure Arc) | SQL |
| Predictable cost modeling | SQL |
| Prefer SQL ecosystem | SQL |
| Reuse existing SQL environments | SQL |
| General-purpose or default use cases | Azure Storage |
Configuration via Azure Portal
Prerequisites:
- Azure Subscription
- Azure SQL Server and Database
SQL Setup:
- Navigate to Security > Networking > Public Access > Exceptions.
- Enable “Allow Azure services…” in SQL Server settings.
- Ensure “Support only Microsoft Entra authentication” is unchecked.
Note: this can be done during SQL server creation from the Networking tab.
Logic App Setup:
- Create a new Logic App (Standard).
- In the Storage tab, select SQL from the dropdown.
- Add your SQL connection string (replace {yourpassword} as needed).
Verification Tip: After deployment, check the environment variable Workflows.Sql.ConnectionString to confirm the SQL DB name is reflected.
Known Issues & Fixes
| Issue | Fix |
|---|---|
| Could not find a part of the path ‘C:homesitewwwroot’ | Re-enable SQL authentication and verify path settings. |
| SQL login error due to AAD-only authentication | Disable AAD-only mode and enable SQL authentication. |
Final Thoughts
SQL as a storage provider for Logic Apps opens up new possibilities for hybrid deployments, performance tuning, and cost predictability. While still in preview, it’s a promising option for teams already invested in the SQL ecosystem. If you are already using this as an alternative or think this would be useful, let us know in the comments below.