Hi,
I am trying access UserProfileService Web service on InfoPath 2010 Web browser Administrator Approved Forms (Domain/Full) to populate the User Details on form Load .I am using claim based Kerberos authentication website.
I have configured the SPN for website and SQL server to use Kerberos authentication.This forms works in Preview Mode using claim based Kerberos authentication website and in browser & Preview Mode with using claim based NTLM authentication.
My web site has anonymous and impersonation authentication is disabled in IIS.I have disabled the sable the authentication loopback check by DisableLoopbackCheck=1 in registry I go the following error on browser......An error occurred while trying to connect to a Web service. An entry has been added to the Windows event log of the server. Log ID:5566 Correlation ID:381b95c1-df14-42e7-9285-bf75830d2b3f In Log file I got the below error...
The following query failed: UserProfile (User: 0#.w|domain\username, Form Name: IP: , Connection Target: , Request: http://sitename/_layouts/FormServer.aspx?XsnLocation=http://sitename/sites/IT/FormServerTemplates/UserProfileServiceTest4000.xsn&SaveLocation=http:// sitename /sites/IT/SupportServices/UserProfileTest&ClientInstalled=false&Source=http://sitename/sites/IT/SupportServices/UserProfileTest/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:UserProfileServiceTest4000:-myXSD-2012-04-11T11-40-37 Type:
DataAdapterException, Exception Message:
The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized.)
I have followed the work around suggested and tried to test it by providing explicit data connection
File and putting
DOMAIN\test.user1
12313d2
Or on form load b y changing the Account name by
http://stevessharepointnuggets.blogspot.co.uk/2012/03/infopath-2010-using-user-profile.html?m=1
concat (“domain\”,username()) or substring-after (username(),”|”) and call web service to get the data.
I think I have tried all the options available to solve the 5566 error but could not get any success.
Please help me
Thanks in advance