cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dual Super User
Dual Super User

Powerapps gateway connection to SharePoint 2016 on-premises

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft dimazaid
Microsoft

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.

View solution in original post

4 REPLIES 4
Dual Super User
Dual Super User

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

PowerApps Staff archanan
PowerApps Staff

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.

Highlighted
Microsoft RobertBruckner
Microsoft

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

Microsoft dimazaid
Microsoft

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.

View solution in original post

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 (Last 30 Days)
Users online (4,449)