Infopath cannot query from SQL Server

[Ron B.]

We've been trying to create a form that would query our SQL server database,
so users could fill out requests and submit to a Sharepoint library. When we
preview we can see it fine, but as soon as we publish it as a form on
sharepoint, we get an "access denied" error when the form tries to query for
data.

We've isolated the issue to this: I set the form's preview settings to
preview as if it were published from our sharepoint domain -
http://home.domain.com . When we preview the form this way, we get the same
error. We get the error whether we view the form in Infopath or as a
Sharepoint Web Form.

Any idea how we can resolve this? We're trying to win our Mac users over
from Filemaker to SQL Server and this obstacle isn't helping our cause.

 

[Ron B.]

Here's the details of the data connection error I get:
The query cannot be run for the following DataObject: tblOrders
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

 

[Ron B.]

Looks like it's a domain trust issue. If I allow the form full trust then
the data connection works fine. But there's no way we can work with full
trust, and no reason we should. So my question is, where is this form going
outside our domain? It's built and saved in the domain, the SQL server is
inside the domain, the website belongs to the domain.

Does sql server need windows domain login too or can we use SQL login?

 

[Ron B.]

Well I talked to Microsoft about this and they gave me the answer. Turns out
the issue is an obscure setting in IE, which restricts accessing data across
domains.

 

[tStat]

Found the answer here
http://www.mrdatamodel.com/KB/Wiki Pages/InfoPath 2007 won't submit to database.aspx