
Announcements
Hi all,
I have a solution which works fine in my Dev environment, all the flows reading/writing to the SQL database work fine. I migrated the app as a managed solution to a Prod environment and the SQL connection doesn't seem to work properly - the app monitor gives me a "Connection not configured for this service" error for all the flows.
The service principal is added as an app user in the environment, and I tried testing a few flows individually and they do work, the issue seems to be just when I try to use them within the app.
Any idea why this might be happening? Thanks in advance for any help
Hi @K_V_25 ,
It sounds like your service principal doesn't have privileges to run your SQL actions; confirmed by you running this outside of the app. Have you considered making the S/P the owner? This will force the appropriate authentication/connection.
Please mark as a solution and/or give me a thumbs up for replying and offering help! Always glad to help! Tom 👍🏽