I was trying out a sample infopath form workflow on my K2 training VPC and it worked fine. I got in trouble, when I tried to create a similar workflow in my production environment.
My production environment has three separate servers. One each for Moss, Sql Server 2005 and K2 installations.
I getting the following error when submitting an infopath form, which uses a couple of Dynamic Sql Server Smartobjects:
An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:5566 |
In the Sql machines event viewer, I found the following Failure Audit Entry:
Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 10/8/2008 Time: 4:47:07 PM User: NT AUTHORITYANONYMOUS LOGON Computer: SQL-Server Description: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. eCLIENT: 99.99.99.99] For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 18 48 00 00 0e 00 00 00 .H...... 0008: 0a 00 00 00 53 00 50 00 ....S.P. 0010: 53 00 33 00 2d 00 53 00 S.3.-.S. 0018: 47 00 50 00 31 00 00 00 G.P.1... 0020: 07 00 00 00 6d 00 61 00 ....m.a. 0028: 73 00 74 00 65 00 72 00 s.t.e.r. 0030: 00 00 .. |
Below is the log file entry from Sharepoint Server.
w3wp.exe (0x1250) 0x131C Forms Server Forms Services Runtime - Data C 82fy Warning The following query failed: LeaveDetails_Create (User: DomainSPAppPoolAccnt, Form Name: Leave Application, IP: , Request: http://intranet/_layouts/Postback.FormServer.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:Leave-Application:, Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error. Server was unable to process request. ---> Message: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.; ServiceName: SQLService; ServiceGuid: 56f91c3b-51d6-4456-bcbd-a098f21dbfda; InnerExceptionMessage: ; The remote server returned an error: (500) Internal Server Error.) 3d9e3fb0-57c9-452f-a80f-9cddbf5715af |
The Dynamic SQL service Object instance is configure to connect to my custom database using SA account and I have disabled impersonation.
Thanks is advance for your help.