web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL connection not wor...
Power Automate
Unanswered

SQL connection not working properly after migrating to different environment

(1) ShareShare
ReportReport
Posted on by 2

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 

Categories:
I have the same question (0)
  • trice602 Profile Picture
    15,404 Super User 2025 Season 2 on at

    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 👍🏽

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard