The error is across most of my database connections and its inconsistent

💬 Queries and Resources
1
  1. My goal: Fix the connection issue
  2. Issue: Connection is inconsistent on my microsoft sql databases. it was working fine for months only today have users been complaining
  3. Steps I've taken to troubleshoot: IT has looked into it, nothing has changed database wise across the separate databases. And no changes were made from my side please assist
  4. Additional info: (Cloud or Self-hosted, Screenshots)
1 Like
2

Summary

Multiple Microsoft SQL Server database connections in Retool have suddenly become inconsistent/intermittent as of today, despite working reliably for months, with no changes reported on the database side (confirmed by IT) or the Retool side.

AI Response

A very recent Retool change is the most likely culprit for MSSQL resources that break suddenly with no database-side changes: as of July 27, 2026, self-hosted deployments now reject Microsoft SQL Server resources using Windows Authentication with custom ODBC connection parameters that are not on Retool's approved allowlist (previously these were only logged as warnings). If this applies, search the dbconnector/backend logs for 'MSSQL Windows Auth ODBC connection string parameter not on allowlist', then remove or replace the flagged keys (for example, use the resource SSL/TLS settings instead of Encrypt/TrustServerCertificate, and ConnectRetryCount/ConnectRetryInterval instead of LoginRetryCount/LoginRetryInterval). If the behavior is truly intermittent rather than a hard failure, it more closely matches known Azure/MSSQL idle-connection drop-outs, which have a documented solved workaround.

Sources

:bookmark: Microsoft SQL Server (Windows Authentication): unsupported ODBC connection params are now rejected
Announces the July 27, 2026 change that now blocks self-hosted MSSQL Windows Auth resources with unsupported ODBC connection params, including how to detect affected resources and remediation steps.
:bookmark: retool->Azure SQL intermittent connection issue
A solved thread on intermittent Retool-to-Azure/MS SQL connection failures that corroborates the inconsistent-connection symptom and shares an accepted fix.

The Community Team is testing out a new automation. Let us know if it's helpful (or not) by leaving a :heart:, :+1:, or :-1:. Or by marking this post as the "Solution"! Let us know if you have any feedback here. :rocket:

3

Hi @BlurCantCode ,

Could you please check Retool's current status here: https://status.retool.com/?

Retool has reported some inconsistencies affecting queries, which may be the reason you're seeing connection errors or other issues.

Please keep an eye on the status page. Once Retool confirms the issue has been resolved, try again. If you still experience the same problem, please share the details here along with screenshots so we can better understand and investigate the issue.

Thank you!

4

Thanks i did check that page and noticed nothing when i was viewing it but now see it has been logged. Much appreciated

1 Like
5

Can you be a little more specific about the exact failure mode, @BlurCantCode? Or let me know if this seems to be resolved? The incident that we logged this morning was fairly narrow in scope and only impacted the way configuration variables with a default value were being read.

1 Like