Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Infopath 2007 submitting to SQL

Posted on 2011-09-14
2
Medium Priority
?
302 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:jkeegan123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
arduk earned 1500 total points
ID: 36540205
I am not sure if this will help, but it may be worth having a look at your alternate access mapping settings - I have seen this cause issues with data connections before, but it was generally when users were connecting using different urls, which may not be the case for you.

Also, check what zone the site is coming up in when users try to connect using the VPN.

You need to try to establish where the access denied message is coming from - is it on the SQL server (the sql logs should show you if it is), or is it before this?

May be worth doing a network trace (using something like wireshark) to check what traffic is coming and going, and particularly what urls are being used

Not really an answer, but may help get you on the right track?
0
 
LVL 5

Author Closing Comment

by:jkeegan123
ID: 36895757
Issue was the SQL server not getting resolved by VPN clients, a host file entry fixed this.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question