InfoPath via SharePoint to SQL SOAP WebService/EndPoint

Question

I have an InfoPath form that connects to a SQL Server EndPoint.  When I created the EndPoint I created it with a specific domain account [DOMAIN\InfoPath_SQL].

When I run the the query from infopath via a button, the database is successfully queried, and data returned.  Keep In mind, I am a member of the SQL Server\SysAdmin role.

When I try to run to the form as a user, then press the query button, I am prompted for permissions to the WebService. (and their Domain permissions do not work)

I have created and AD Group, and added the users to the AD group.

-I have added the group to the SQL server.

-I have granted impersonate permissions to the account for the web service.

     GRANT IMPERSONATE ON LOGIN::[DOMAIN\infopath_sql] to [DOMAIN\InfoPathSQL_Users];

- I have granted connect permissions to the group

    GRANT CONNECT ON ENDPOINT::InfoPath_endpoint TO [DOMAIN\InfoPathSQL_Users]

- I have given both the User Group and the individual account I created the endpoint with db_owner permissions to the DB. ( I want to remove this)

Still i receive: The Web service request could not be authenticated.

Any ideas?

Answer 1

Hi GregCrossan,
Thank you for posting. 
I will help you involve others to help you. There might be some delay about the response. Appreciate your patience.
Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi GregCossan,

I would like to ask a few initial questions:

- When you run this as a normal user, is the form opening in the InfoPath client or in a browser form? (Is this the same as when you tested or did you just Preview the form in the client and test?)

- Have you checked the IIS logs to see if these shed any light on the failure? 

- Assuming this is a browser error, how many Web Front Ends (WFE's) are in your farm serving content? 

- Is the web service on the WFE's or a separate server?

Thanks,

Scott Heim

---

Scott Heim - Microsoft Office InfoPath and SharePoint Designer Online Community Support

Answer 3

Scott,

The SharePoint 'Farm' actually only consists of one WFE.    The InfoPath form is opening in the InfoPath Client, as 'InfoPath Services' are not installed on this Server. It is (WSS 3.0 not MOSS)

Both SharePoint (IIS) and the DB reside on the same physical server. (Yes I know against Best Practices, but that is another story).

Thanks for your help.

Answer 4

Hi GregCossan,

Thanks for the additional information.

A few more questions:

- Are you familiar with the Fiddler (http://www.fiddler2.com) network capture tool? It may be worthwhile to capture a network trace using Fiddler (since InfoPath just uses HTTP/HTTPS, Fiddler is a great tool for this) or Netmon to confirm what you are seeing.

- Have you taken a SQL Profiler trace? Again, most likely you are not getting to SQL but let's be 100% sure.

- What about the IIS logs? Are you seeing any kind of error (i.e a 401) just getting to the web service itself? This would help confirm if it is just getting to the web service that is the issue or executing the web service. 

- Out of curiosity, what happens if you just create a local SQL Server user and use those credentials instead of a special domain account...any change in behavior?

- What is the exact text of the error you are seeing?

Thanks,

Scott

---

Scott Heim - Microsoft Office InfoPath and SharePoint Designer Online Community Support

Answer 5

FYI - I figured it out.   I had to do with KERBEROS and NTLM.   If I removed KERBEROS from the authentication it works fine.