Infopath 2007 submitting to SQL
Posted on 2011-09-14
We have several Infopath forms published to a Sharepoint 2010 server. The Infopath forms submit data to a SQL 2008 R2 database, and this works fine for client PCs that are members of the domain.
When a user VPN's in and connects to Sharepoint from their home PC or laptop, however, the form loads in Infopath but fails to submit to SQL. All field sales people have their own laptops that almost never are connected to the domain, and more than half of these laptops aren't even members of the domain.
I'm not sure where to start looking for where this is breaking. The Infopath form has all of the data connections defined and submits data correctly for users that connect from a PC that is on the domain, but through VPN, I get the following error:
"Infopath cannot connect to the data source, access is denied."
Is this permissions submitting to SQL? Is there a way to embed credentials to submit to SQL into the infopath form? The latter sounds like a bad idea from a security standpoint, but how do others work it so that VPN users can connect to a Sharepoint intranet and fill out Infopath forms that submit to a database? I can't be the first person to try to do this.
Any help is appreciated.