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.
all sorted above. It was permission issue.