Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : 5o4Yb//Oetnn4dPcd77JTq
Power Platform Community / Forums / Power Apps - Building Power Apps / Powerapps gateway conn...
Power Apps - Building Power Apps
Answered

Powerapps gateway connection to SharePoint 2016 on-premises

Like (0) ShareShare
ReportReport
Posted on 12 Aug 2016 12:40:32 by darogael 123 Most Valuable Professional

I'm attempting to setup and configure the gateway on my On-Premises SharePoint 2016 server. The gateway installation was successful but now I'm stuck on the configuration. I confirmed that the account I am using does have access to the PowerApps subscription. Also, when I go to PowerApps site, connections and try to make a SharePoint on-premises connection I do see my connection name.

I did look at the 'Troubleshooting the On-Premises gateway article' and did run the below command and confirmed I was successful.

 Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

Looks like I'm very close to getting this to work.

Below is the error I keep getting

Capture2.JPG

Let me know if I need to post that entire log text

Categories:
Connecting to Data
  • Verified answer
    dimazaid Profile Picture
    dimazaid Microsoft Employee on 16 Aug 2016 at 19:57:24
    Re: Powerapps gateway connection to SharePoint 2016 on-premises

    Thanks @darogael for walking us thru the issue.

    Just to close on this, the root cause of the error was caused by the wrong time/date configuration in the machine where the gateway is being configured. Fixing these settings have fixed this issue.

  • RobertBruckner Profile Picture
    RobertBruckner Microsoft Employee on 12 Aug 2016 at 19:33:30
    Re: Powerapps gateway connection to SharePoint 2016 on-premises

    Hi darogael,

     

    Based on the messages you posted, we think you are running into a bug on our side. Good news is that there are three options:

     

    1. Workaround:

    As a workaround, uninstall the current On-premises data gateway, logoff, and then login as local administrator on that machine. Install the On-premises data gateway and go through the configuration like you did before, and let us know if that worked.

     

    2. Fix: we believe we have a fix for the underlying issue, and plan to include it with the next public release of the On-premises data gateway planned at the end of August. When you install with that update, you should not encounter the problem anymore.

     

    3. Beta-test the fix:

    If you send a private email message to Robert.Bruckner at microsoft.com, we could look into sharing a private preview build of that August public release for you to try out the code change we made.

     

    Thanks,

    Robert Bruckner

  • AN-23072011-0 Profile Picture
    AN-23072011-0 on 12 Aug 2016 at 18:26:01
    Re: Powerapps gateway connection to SharePoint 2016 on-premises

    Thanks for reporting this issue. We are looking into it and provide you an update shortly.

  • darogael Profile Picture
    darogael 123 Most Valuable Professional on 12 Aug 2016 at 14:58:34
    Re: Powerapps gateway connection to SharePoint 2016 on-premises

    Here is some added information I found while looking at the log file

     


    Microsoft.IdentityModel.Clients.ActiveDirectory Error: 4 : 8/12/2016 10:00:40 AM: e8111417-699c-4ebd-a1e4-68ba47452dfc - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.VerifyAuthorizationResult()
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.PreTokenRequest()
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
    ErrorCode: user_interaction_required
    EnterpriseGatewayConfigurator.exe Error: 0 : 8/12/2016 10:00:40 AM: e8111417-699c-4ebd-a1e4-68ba47452dfc - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.VerifyAuthorizationResult()
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenInteractiveHandler.PreTokenRequest()
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
    ErrorCode: user_interaction_required
    EnterpriseGatewayConfigurator.exe Warning: 0 : Error authenticating current user with forms authentication: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame. Attempting Windows integrated authentication.
    EnterpriseGatewayConfigurator.exe Warning: 0 : Exception details: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: user_interaction_required: One of two conditions was encountered: 1. The PromptBehavior.Never flag was passed, but the constraint could not be honored, because user interaction was required. 2. An error occurred during a silent web authentication that prevented the http authentication flow from completing in a short enough time frame
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.RunAsyncTask[T](Task`1 task)
    at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.AuthenticationManager.TryAuthenticateWithCurrentUser(AuthenticationResult& authResult)
    ErrorCode: user_interaction_required
    Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AcquireTokenNonInteractiveHandler: === Token Acquisition started:
    Authority: https://login.windows.net/common/oauth2/authorize/
    Resource: https://analysis.windows.net/powerbi/api
    ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
    CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
    Authentication Target: User

    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AcquireTokenNonInteractiveHandler: === Token Acquisition started:
    Authority: https://login.windows.net/common/oauth2/authorize/
    Resource: https://analysis.windows.net/powerbi/api
    ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
    CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
    Authentication Target: User

    Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Logged in user with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected
    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Logged in user with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected
    Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: Looking up cache for a token...
    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: Looking up cache for a token...
    Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: No matching token was found in the cache
    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - <RunAsync>d__0: No matching token was found in the cache
    Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Sending user realm discovery request to 'https://login.windows.net/common/UserRealm/first.last@domain.com?api-version=1.0'
    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Sending user realm discovery request to 'https://login.windows.net/common/UserRealm/first.last@domain.com?api-version=1.0'
    Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: User with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected as 'Managed'
    EnterpriseGatewayConfigurator.exe Information: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: User with hash 'c1bLDYhsIkroCaGl90ZMlaVJpVbjG8lTaJZwEcwSA34=' detected as 'Managed'
    Microsoft.IdentityModel.Clients.ActiveDirectory Error: 4 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenNonInteractiveHandler.<PreTokenRequest>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
    ErrorCode: password_required_for_managed_user
    EnterpriseGatewayConfigurator.exe Error: 0 : 8/12/2016 10:00:40 AM: 4694aded-9f48-4ffd-bdde-cb6810d651f6 - AsyncMethodBuilderCore: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenNonInteractiveHandler.<PreTokenRequest>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AcquireTokenHandlerBase.<RunAsync>d__0.MoveNext()
    ErrorCode: password_required_for_managed_user
    EnterpriseGatewayConfigurator.exe Warning: 0 : Error authenticating current user with Windows integrated authentication: password_required_for_managed_user: Password is required for managed user. Giving up - user has to enter credentials.
    EnterpriseGatewayConfigurator.exe Warning: 0 : Exception details: Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: password_required_for_managed_user: Password is required for managed user
    at Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext.RunAsyncTask[T](Task`1 task)
    at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.AuthenticationManager.TryAuthenticateWithCurrentUser(AuthenticationResult& authResult)
    ErrorCode: password_required_for_managed_user
    EnterpriseGatewayConfigurator.exe Warning: 0 : Could not acquire authentication token for current user.
    EnterpriseGatewayConfigurator.exe Information: 0 : Configuration Id: '27338'
    EnterpriseGatewayConfigurator.exe Information: 0 : SB Endpoint: 'sb://wabi-us-east2-relay43.servicebus.windows.net/c0d3560e-1622-4537-85cd-66263ec84d1f/'
    EnterpriseGatewayConfigurator.exe Information: 0 : Sign In

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans