I have question regarding Infopath using Web service (Userprofileservice). It works fine at preview. once I publice to the SharePoint site it works fine I open in client application but get error when I choose to “display as a web page” I get error called Data can not be accessed: 5566
It’s obvious that it’s a security issue, but hard to tell what’s going on without digging into it. My guess is going to be that it’s a “double hop” issue meaning the proper credentials are not getting passed like they should.
Usually, the solution to this would be either configuring Single Sign On or Kerberos. I suggest you look into that.
View 
Subscribe via 
Leave a Comment
October 6, 2009 pm31 3:12 pm
Thank you for the videos that are very useful.
I have question regarding Infopath using Web service (Userprofileservice). It works fine at preview. once I publice to the SharePoint site it works fine I open in client application but get error when I choose to “display as a web page” I get error called Data can not be accessed: 5566
Event log : “the following query failed: GetUserProfileByName (User: domain\username, Form Name: Test User Name with Web Service, IP: , Request: https://server/_layouts/FormServer.aspx?XsnLocation=https://server/ncss/helpdesk/Explore/Test+User+Name+with+Web+Service/Forms/template.xsn&SaveLocation=https://server/ncss/helpdesk/Explore/Test+User+Name+with+Web+Service&Source=https://server/ncss/helpdesk/Explore/Test%2520User%2520Name%2520with%2520Web%2520Service/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:Test-User-Name-with-Web-Service:-myXSD-2009-10-05T18-57-10, Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error.
Server was unable to process request. —> Attempted to perform an unauthorized operation.
The remote server returned an error: (500) Internal Server Error.”
I have used the UDC and DCL for Dataconnection to InfoPath
Thank you
Kanta
October 6, 2009 pm31 6:04 pm
It’s obvious that it’s a security issue, but hard to tell what’s going on without digging into it. My guess is going to be that it’s a “double hop” issue meaning the proper credentials are not getting passed like they should.
Usually, the solution to this would be either configuring Single Sign On or Kerberos. I suggest you look into that.