Skip to main content

Notifications

Power Automate - General Discussion
Answered

Execute Store Procedure using power automate error

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

 

Hope you are doing well. I have got store procedure in SQL server and I am trying to execute using power automate.

 

Here is the scenario:

I have two database in my SQL server A and B. Database A get restore every night with updated copy which contains all the tables. Database B hold store proc and brings data from A to B.  

In power automate I have made connection using database B and by using Execute stored procedure (V2) I have created the flow but it gives following error.

 

Microsoft SQL: The server principal "PowerApp" is not able to access the database "A" under the current security context.
inner exception: Microsoft SQL: The server principal "PowerApp" is not able to access the database "A" under the current security context.

 

Store procedure run perfectly in SQL server but not using power automate. So, if someone can explain what I am doing wrong, would be really helpful?

 

Thanks.

  • Verified answer
    Re: Execute Store Procedure using power automate error

    all sorted above. It was permission issue.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard