We have an InfoPath form running under InfoPath forms services that opens a data connection to a SQL database to invoke a stored procedure using Integrated Security. It connects as NT AUTHORITY\ANNONYMOUS LOGIN and is denied access.
The following query failed: CPI_RPI_Table (User: LITWARE\smith, Form Name: CPI-RPI-Index-Published, IP: , Request:
https://www.litware.com/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:CPI-RPI-Index-Published:-myXSD-2010-09-14T19-44-07, Type: DataAdapterException,
Exception Message: The form cannot connect to the data source. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.)
When we run it in the InfoPath client, it connects with the users credentials.
Can we have the form default to another identity, that of the SharePoint Service acount?
View Complete Post