Data Connections

Re: Data Connection to SharePoint Online (SSO/ADFS)

Hilary Stoupa — Fri, 15 Sep 2017 15:27:20 GMT

Thank you so much for posting the resolution! I'm glad you found it. :)

Re: Data Connection to SharePoint Online (SSO/ADFS)

scarlson — Fri, 15 Sep 2017 14:41:54 GMT

The issue was "modern authentication' by default is not enabled in InfoPath. For our tenant we have;

LegacyAuthProtocolsEnabled="F" -- apparently needs to be for 2-factor authentication (which we have set-up for admin accounts)

The fix is either have this flag set to "Y' or modify the registry;

HKCU\SOFTWARE\Microsoft\Office\15.0\Common\Identity\EnableADAL	REG_DWORD	1
HKCU\SOFTWARE\Microsoft\Office\15.0\Common\Identity\Version	REG_DWORD	1

Re: Data Connection to SharePoint Online (SSO/ADFS)

scarlson — Thu, 14 Sep 2017 18:03:52 GMT

I checked the "keep me signed in" box. The site is in Trusted Sites

Re: Data Connection to SharePoint Online (SSO/ADFS)

Hilary Stoupa — Thu, 14 Sep 2017 17:51:58 GMT

So - dumb question - but have you selected "remember me" when logging into SharePoint? Or since you are using SSO, that isn't needed? Is the site in your local intranet in IE?

Re: Data Connection to SharePoint Online (SSO/ADFS)

scarlson — Thu, 14 Sep 2017 16:27:47 GMT

Thanks -- Here is what I get in fiddler;

--I believe my credentials are not be authenticated/passed (Authentication Header not being passed?) I tried on both a windows 7/10 machines; I'm Gobal Admin/Site Collection Admin

HTTP/1.1 401 Unauthorized
Content-Type: text/plain; charset=utf-8
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-SharePointHealthScore: 0
SPRequestGuid: 9835199e-c02f-4000-829f-d7dff1854abd
request-id: 9835199e-c02f-4000-829f-d7dff1854abd
X-MSDAVEXT_Error: 917656; Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically.
X-Powered-By: ASP.NET
MicrosoftSharePointTeamServices: 16.0.0.6906
X-Content-Type-Options: nosniff
X-MS-InvokeApp: 1; RequireReadOnly
X-MSEdge-Ref: Ref A: 4E2B24723E2C4A73889F0FDDC9040447 Ref B: BLUEDGE0922 Ref C: 2017-09-14T16:15:41Z
Date: Thu, 14 Sep 2017 16:15:41 GMT
Content-Length: 0

Re: Data Connection to SharePoint Online (SSO/ADFS)

Hilary Stoupa — Thu, 14 Sep 2017 16:01:26 GMT

Oh wow, that's totally unhelpful. I'll ping Jim and see if he knows anything.

Re: Data Connection to SharePoint Online (SSO/ADFS)

scarlson — Thu, 14 Sep 2017 15:54:20 GMT

sorry about that;

Re: Data Connection to SharePoint Online (SSO/ADFS)

Hilary Stoupa — Thu, 14 Sep 2017 15:09:36 GMT

Your screenshot doesn't show - can you attach it again under the options tab?

Data Connection to SharePoint Online (SSO/ADFS)

scarlson — Mon, 11 Sep 2017 22:45:07 GMT

Hi -

We are moving from SP 2010 on prem to Office 365 in the cloud. I know Office 2010 has a issue connecting to (SSO) but, we have upgraded. I have converted to InfoPath 2013 and was able to connect to a SharePoint list in our test tenant. The issue is our prod tenant has SSO and when I try and connect to list I get;

and fiddler doesn't offer much.

I tried setting trusted sites and "automatic logon with username and password" w/o success.

We are trying smart links and auto acceleration setting i.e Set-SPOTenant –SignInAccelerationDomain “” to find the "home realm" Has anyone seen this issue? I'm guessing it's some restriction we have in our production environment.