Solved

Submitting InfoPath Form to SQL database through webservice

Posted on 2012-03-29
3
651 Views
Last Modified: 2012-05-03
Hello,

I have created the InfoPath Form and End Point in SQL. When I submit the form to the webservice through InfoPath client, it works with no problem. However, when I submit through web-browser, I have the following error;

There was an error in the incoming SOAP request packet:  Client, LoginFailure, AccessDenied  SOAP-1_2-ENV:Sendersqlsoapfaultcode:LoginFailuresqlsoapfaultcode:AccessDenied There was an error in the incoming SOAP request packet:  Sender, LoginFailure, AccessDenied http://hqsql1:80/ins_Name_WbSrvsTest http://schemas.microsoft.com/sqlserver/2004/SOAP The remote server returned an error: (500) Internal Server Error.)

How can I fix it?

Thank You

Orrin
0
Comment
Question by:orrin05
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 37783270
In SharePoint, you must setup a UDC connection for browser based forms.

In the Data Connections window in IP, there is a button on the side to convert a data connection to a UDC.  This means that SharePoint will use a library to store these connections.

You also may encounter the "double hop" issue where SharePoint has a hard time authenticating with another server.  

You can research more on www.infopathdev.com.
0
 

Author Comment

by:orrin05
ID: 37784102
Hello clayfox,

I already have my UDC connection. I am probably having a hard time authenticating with another server. I will be appreciated with any solution you have. I also look into msdn and infopathdev.

Thanks
0
 

Author Comment

by:orrin05
ID: 37784325
Clayfox,

I found some of your posts in infopath dev about "double hop" issue, I am still searching, but if you have possible solutions, I would like to hear them.

Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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