Qdabra Database Accelerator

Re: Publishing form data on duplicate systems with no shared authentication method

GedCT — Tue, 21 Sep 2010 12:51:44 GMT

Thanks Jim. Would you happen to know whether SSO is supported by SharePoint Foundation 2010, as otherwise I'll have to shell out on an upgrade :0)

Ged

Re: Publishing form data on duplicate systems with no shared authentication method

Jim Cantwell — Thu, 02 Sep 2010 16:10:16 GMT

For the submit to SharePoint, you will need to configure Single Sign-On and use SSO in the SharePoint mapping. SQL access will always be done using the DBXL app pool account, or the SQL Authentication specified in the database connection string.

Publishing form data on duplicate systems with no shared authentication method

GedCT — Thu, 02 Sep 2010 12:00:40 GMT

I currently run the DBXL tool on two connected systems with no trust relationship between them - which is something which I cannot change. As a result, there is no shared Active Directory or any other method for sharing login credentials.

System A is able to access resources on System B, but the reverse connection is not allowed. I have created an InfoPath form that allows data to be transmitted to the DBXL web service on System A which is subsequently shredded into a SQL database and the form displayed within a suitable library. I now want to add a second connection to the form which submits the data to the DBXL web service hosted on System B which will then also publish the data into SQL and SharePoint.

I have a domain account set up System B that has the necessary permissions into the SQL and SharePoint instances and want the form on System A to use this domain account, since not all users submitting the form data have accounts on System B's network.

Is there a way in which I can direct the second web service to use a specific account to carry out the submit action?