InfoPath Dev

Is it possible to use Integrated Security for a web service used by InfoPath?

I have an InfoPath form that uses a web service defined in a UDC in a data connection library. The UDC has UseFormsServiceProxy="1" and the roxy account has been setup in SQL Server to have access to the dataset. SQL Server is running on a different machine from the web service, but is in the same domain. The web service tries to connect using Integrated Security. When I try to access the data I get the following error:

InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

Server was unable to process request. ---> Login failed for user ''. The user is not associated with a trusted SQL Server connection.

So why is the user not getting passed to SQL Server?

If this is not an appropriate topic for this forum, can anybody suggest a forum that might be more appropriate? Thanks!

I don't have a whole lot of experience in this realm, but this seems like a multi-machine sign on issue. You will need to install Kerberos or enable forms-based authentication to get this to work.

Sorry for the lack of information, but try searching around for enabling Single Sign On or using Kerberos with your version of InfoPath. If you get it figured out, please reply back with what you did!