B2B account access PowerrApp/Sharepoint backend

Like (0) Share

Report

Posted on 12 Jul 2021 21:40:55 by regis5635

I have a power app that stores photos on a sharepoint backend. I need to give access to a set of our companies B2B 'Partners'. We also would like them to access SQL Server too. Having trouble figuring out which MS licenses are required to run the app. Currently have Power Apps (power app front end) and MS Project Essentials (solves the Sharepoint one) but still have issues because it prompts for SQL Server license. What is the standalone SQL Server license that I can assign to these partners to allow that part of the app to run?

All responses (1)

Answers (0)

joe_hannes_col 1,843 Super User 2024 Season 1 on 13 Jul 2021 at 10:37:15

Like (0)

Report
Re: B2B account access PowerrApp/Sharepoint backend

Hello @regis5635,

Could you please share a little more detail on the SQL server you are running? Is it a managed SQL database running on Microsoft Azure, or an on-premise one?
Could you share a screenshot of the prompt you mentioned?
Based on your explanations, I would assume you need the following licenses:
Power Apps per apps or per user plan, because you are connecting to SQL server, which requires a premium connector
No SharePoint licenses are required for sharing content externally: https://docs.microsoft.com/en-us/sharepoint/external-sharing-overview#what-happens-when-users-share
SQL server licenses: It is my understanding that you do not need individual user licenses for managed SQL databases running on Azure. If you're not using this Azure service, please share more details on the version of SQL you are running and the licensing model you are using.