New SP Data Connection In New Form - Access Denied - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

New SP Data Connection In New Form - Access Denied

Last post 10-05-2022 11:50 AM by Hilary Stoupa. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-03-2022 02:48 PM

    New SP Data Connection In New Form - Access Denied

    Here is a brand new and interesting issue I'm facing and I am hoping someone has an idea as to how I could troubleshoot this: With a completely blank SharePoint List or SharePoint Form Library Form in IP 2013, the wizard will request the site URL and prompt for NTLM Windows authentication (Claims based) and will subsequently fail with the error "Access Denied". Subsequently, if I open an existing form and attempt to edit the data connection, I receive a similar "Access Denied" message. I have repeatedly tested this against our production 2016 Ent. Farm and cannot reproduce this as it works in our mirror test env. I have tried with various users and machines both joined and not joined to our domain. Where this gets interesting is that if I open SP Designer and then go to a list and "Design in InfoPath" where it will open IP, I'm prompted for credentials and can both edit existing data connections to sharepoint lists as well as create new ones and browse any available list without an issue. Can anyone please explain what in the world is going on and how to attack the problem???!!! My original thought was that something in IPFS had gone wonky as I'm seeing several logs from infopath where Writing log usage failed during CalculatedField operation, but I'm not certain that the two issues are related.
  • 10-05-2022 11:40 AM In reply to

    Re: New SP Data Connection In New Form - Access Denied

    The cause of this issue was the result of moving my primary system into a new GPO where my SP Farm wasn't listed as a trusted site. (The secondary system I tested this on was not joined to the domain, nor was the site in the Trusted Internet Zone). After adding my SP site back to the Trusted Sites Zone via I.E. settings, I was able to open a new form and add a data connection. -I'm not sure why the test site worked as it wasn't a trusted site, either. -Hope this helps someone who might be having this error.
  • 10-05-2022 11:50 AM In reply to

    Re: New SP Data Connection In New Form - Access Denied

    Wow, fantastic job finding and fixing this, and thank you so much for posting your solution!
    Hilary Stoupa

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.