cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BrianHFASPS
Level 8

SQL Access permissions issue - Granted Everyone and still fails?

I have an app that I have expanded usage from 1-3 users to almost all my users. To enable this I first tried sharing it with an AD group. That didn't seem to work. Then I tried using Everyone and that still doesn't work. I finally tried adding the user directly and it still doesn't work. I am at a loss for why it isn't working?

Here is the message the users are getting:

SQL Permission needed.pngSQL Permission request

This is the permissions I granted to app:

App Permissions.pngApp permission sharing

Finally here is the SQL connection permissions:

SQL Permission granted.pngSQL Permissions Granted

 

My only guess is maybe the allowed connections to Azure SQL is based upon site IP and the permssion request must be approved from there? I know I can access it from other IP but I have already granted myself permission. Any ideas?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 178 members 5,899 guests
Please welcome our newest community members: