Thursday, 22 January 2015

Can't Connect to SharePoint Designer OR can't query GetUserProfileByName Web Service

We were getting an issue on one of our Test Server WFE's where we were having two issues:

- If you were trying to load an InfoPath form that contained a connection to the GetUserProfileByName Web Service, it would fail.
- If you tried to connect to the site via SharePoint Designer, it would error out.

SO!  If you get any of the following issues:

In SP Designer:
"The server could not complete your request.  For more specific information, click the Details button."


"An error occurred while trying to fetch data from your SharePoint site.  Unexpected response from the server.  The content type of the response is "", The status code is "OK"."


On an InfoPath Form:
"There has been an error while processing the form.  An error occurred while trying to connect to a Web service"


In SharePoint Logs:
"The following query failed: GetUserProfileByName (User: xx\username, Form Name: Template, IP: , Connection Target: , Request: http://root/site/Lists/ListName/AllItems.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:list:-AutoGen-2014-11-13T05:55:39:175Z Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized.)"


Here's how we solved the problem:
Navigate to the server in question
Open IIS Manager > Navigate to the site that is causing the problems
Click on Authentication > Windows Authentication > Providers...

Our Enabled Providers had been changed, and was set to Negotiate: Kerberos (wasn't the same on the prod servers...).  So I changed the Enabled Providers back to 'Negotiate' & 'NTLM'.

After an IISRESET, good as gold.


No comments:

Post a Comment