Power Automate + BBCRM Read-Only Database (RODBA) – has anyone successfully connected?

Hi all,

I’m reaching out to see if anyone has successfully connected Power Automate to the Blackbaud CRM read-only database (RODBA) using the SQL Server connector.

For context, our BBCRM is fully hosted by Blackbaud (Azure SaaS), and we have the optional read-only database access enabled. We can successfully connect to RODBA via Power BI using the on-premises data gateway, and also connect directly using SSMS.

We’re now trying to establish a connection from Power Automate using the SQL connector. While we can select the same on-premises data gateway used for Power BI, we haven’t been able to get the connection to succeed.

What we’re seeing

• The connection test fails when creating the SQL connection in Power Automate
• Error message indicates login failure due to trigger execution:

Microsoft SQL: Logon failed for login due to trigger execution. Changed database context to ‘[db]’. Changed language setting to us_english.

Our current thinking

We suspect this may be related to a combination of IP whitelisting and/or encryption or validation requirements on the server side. A few observations:

• Unlike Power BI, there is no option to skip the test connection in Power Automate
• There doesn’t appear to be a way to explicitly enforce encryption in the connector
• The same gateway and credentials work successfully in Power BI

Question
Has anyone:

• Successfully connected Power Automate to BBCRM RODBA?
• Encountered similar login/trigger issues?
• Found any workarounds or required configurations (e.g. gateway settings, connector behaviour, or BB-side changes)?

Any guidance or experience would be really appreciated. Happy to share more detail if helpful.

Thanks in advance,
Simon