I have a form built for a SharePoint list which when run from InfoPath's preview mode, works fine. It makes a call to a data connection (which has been converted to a connection file and stored in a data connection library in my SharePoint site.
I can see that it talks to the service server (I see the request successfully authenticate in the IIS logs, and I see the service log report that it did what it was supposed to).
When I run the form from the SharePoint site, though, the form will fail. I'll get a correlation id error that basically says the external server refused the connect due to authentication. The service server's IIS logs show that it blocked access to the service... and the service log shows nothing since the request didn't make it that far.
Googling, I found a page that mentions that when doing what I'm doing, the problem might be a double- or multi-hop authentication problem. Reading that, it discusses how to set in your SharePoint Central Admin, you need to mess with the InfoPath Form Services settings "Configure InfoPath Forms Services Web Service Proxy" and turn on features. "Enable InfoPath Forms Services Web service proxy" and "Enable InfoPath Forms Services Web service proxy for user forms" You then are supposed to edit your udcx file to set the allow proxy settings to true.
I'm missing something from this article... I'm not doing something right and I'm looking for others who've successfully set this up and might know if there's a trick or a step i'm missing.
I think I'm trying to make things work like "Multi-tier Web service Authentication using the Proxy: " part of the article mentions... but something just isn't working for me.