Enter your credentials to connect to the following web service: InfoPath 2007

Issue: User get the authentication prompt when trying to open the InfoPath form from a SharePoint form library.

Background:

While submitting the credentials user can open the form, however, when he try to pull some of the information from the drop down menu which is custom felid, he can’t see the information in the field.

 

Basic checks:

1. Initially I though it is a problem of the IE version, So we did some basic level of troubleshooting such as
2. Clearing the IE history,
3. Resetting the IE to factory settings.
4. Repairing the Office using MS office diagnostic tool.
5. Clearing the InfoPath cache from Start -> Select Run- > Enter ‘InfoPath /cache clearall’.
6. Deleted all files and folders within any other folders starting with FormCache: C:\Documents and Settings\[User]\Local Settings\Application Data\Microsoft\InfoPath
   **Note: [User] is your logon ID
7. Asked user to login to any other machine, there we saw the same behaviour.

So this is something not a machine specific issue and not that easy as I was thinking.

 

Troubleshooting:

 

I tried to reproduce the problem with my normal user account.

 

Note: As a SharePoint admin we have two accounts to work with a normal user account and the Account with the farm level admin rights.

 

When accessing the form with the high privileged account I was able to populate the values in the custom field in the InfoPath Form, however, with my normal user account I was also facing the same problem. BOOM…

 

It’s was not something very easy now.

 

I tried to isolate the problem by adding my account at different level of permissions (Read/Contribute/Full Control) at Top level site/sub-site and the doc library level.

 

Nothing worked for me.

 

Now it was something to deal at the form level. I need to dig in the form structure to check where the problem was lying.

 

One was sure that while opening the Form it was talking to the list in the background via a web service (_vti_bin_lists.asmx) as you may have noticed from the authentication box.

1. Edited the form in the design mode.
2. Checked the properties of the drop-down box.

    3. As you can see from the properties the ‘List box entries’ was using the values form external data source. (Note: External data source can be anything like a XML Document, a Database, a Web service and SharePoint Library or list.



   4.This information, you can look at the by adding the data sources to the drop down box.

   5. By modifying we get to know from which list the field was populating the values.
 
   6. Accessed that list from SharePoint site and checked that the list was not inheriting permissions from its Parent site.

   7. Added my normal account and user account with the contribute permissions to the list and tried to access the form again and this time it didn’t asked for any authentication and values were also populating the drop-down of the InfoPath form.

To conclude it was a permissions issue not on the form library though was a permission issue on the list from where Values were populating in the form.

 

If you face any issue or have any concerns, do let me know, it would be happy to help you with.

TechNet Wiki Link:

 

Product Applies to: SharePoint 2007, InfoPath 2007, SharePoint Server 2010 and InfoPath 2010.