SharePoint 2010 -Error in InfoPath web browser form: “An error occurred querying a data source.”
On the Web Application are some browser enabled InfoPath forms. Some of them consume a SharePoint Web Service to query user information. After switching the Web App to HTTPS there was an Error while loading the form in browser.
First error message: “An error occurred querying a data source.”
Second error message: “You do not have permissions to access a Web service that provides data required for this form to function correctly.”
Cause: we are using SSL certificates for SharePoint 2010 web applications and we need to import the certificate into SharePoint trusted root certify ate store in order to InfoPath service to work.
$cert = Get-childItem "cert:\LocalMachine\CA\9A68CD6434D370CA40AA6CF443D86B46D2D3B485" new-SPTrustedRootAuthority -Certificate $cert -Name "Sempra Energy Utilities Root Authority"
One last note – the ‘Get-childItem’ cmdlet can be used to walk the cert store as follows:
Get-childitem “cert:\LocalMachine\ *”