cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LukasNespor
Level: Powered On

On-premises data gateway - SharePoint 2013 unauthorized 401

I have installed and configured the on-premises data gateway on on of our SharePoint 2013 server (Windows 2008 R2). The gateway is visible in PowerApps and is working because I'm able to connect to on-prem SQL server. But connecting to on-prem SharePoint 2013 doesn't work and says 401 Unauthorized.

 

SharePoint site is using SSL and is path based. Login I'm using is correct and able to visit SharePoint site that returns 401 error.

23 REPLIES 23
Community Support Team
Community Support Team

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi LukasNespor,

 

Could you please share more details about the error message, when did it pop out, under Add New Connection in Browser, or when Trying to New an App with the SharePoint connections?

Please make sure the User account used for the SharePoint Connection is authorized to the SharePoint site that you would like to connect, also make sure the proper gateway is selected:

15.PNG

A reference: 

Support for on-premises SharePoint lists

 

For the SharePoint site that could be accessed through Browser, could you please confirm it again with the Account used to create the SharePoint connection?

 

If the error message occurred when trying to create a new App with SharePoint connection, then please make sure the user account has the proper permission to access the site level which specified under the site URL.

16.PNG

Add some additional reference: 

On-premises data gateway in PowerApps

 

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LukasNespor
Level: Powered On

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Error message is just "401 UNAUTHORIZED" with correlation id. It pops out when I try to "Connect to a SharePoint site" (creating new App). Creating connection (where I can select proper gateway) is working but connecting to https://portal.domain.com/sites/somesite ends with error. The account I'm using has access to site and is also able to visit the site in browser. The account is farm admin and has Full control through User policy on web application.

 

02.png

 01.png

 

01.png

Community Support Team
Community Support Team

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi LukasNespor,

 

I saw your SharePoint input site URL is the following:

https://portal.domain.com/sites/workflows/mxxx

How about change the SharePoint URL to the following format?

https://portal.domain.com/sites/

See if this would make any difference.

Regards

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LukasNespor
Level: Powered On

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

If you mean to add slash to the end of url then no, it doesn't help.

Community Support Team
Community Support Team

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi LukasNespor,

 

What is your current situation?

 

Please take a try to modify the URL with the following format:

https://portal.domain.com/

This would list the available source under the top site, check to see if this would work.

 

If issue still insists, please reply back and I will try to involve others to take a further look.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LukasNespor
Level: Powered On

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi,

I have found that the issue is with SharePoint itself. Different SharePoint farm and same Office 365 tenant works well. Firewall is turned off . Are there any prerequisities that the server does not meet?

 

Windows Server 2008 R2 Standard

SharePoint 2013 Ent CU February 2016 (15.0.4797.1000)

Community Support Team
Community Support Team

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi LukasNespor,

 

Thanks for the update.

I will try to involve others who is familar with this to take a further investigation, there might be some time delay.

 

Appreciate your understanding and patience.

 

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LukasNespor
Level: Powered On

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

Hi,

were you able to invole others? Still the same error:

401 UNAUTHORIZED

ID relace: 6acceb07-e92d-17b5-0d6f-1149765c65d6

 

Thanks

Highlighted
alejandrol
Level: Powered On

Re: On-premises data gateway - SharePoint 2013 unauthorized 401

I'm having the same problem.

Any solution for this?

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 (5,741)