infopath form service error connecting to a web service

sharepoint56 — Wed, 14 Jul 2010 23:42:56 GMT

Hello all,

I have a webservice which i have deployed to sharepoint layouts folder and i access it through http://test/_layouts/mywebservice.asmx..now i have a form which has this web service as secondary data connection and what this web service does is that it gets data from sql server which is on a different server..now i convert this data connection to udcx file and then i publish my form to http://test...but when i open thr form in browser i get the below error.it might be a common issue but i am not able to identify what the problem is ..if somebody can guide me then it would really be a great help.

An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.

Log ID: 5566

The sharepoint log files record the following

07/14/2010 16:45:22.25     w3wp.exe (0x5FB0)                           0x0958    Forms Server                      Forms Services Data Objects       13zh    Exception    System.Net.WebException: The remote server returned an error: (401) Unauthorized.     at System.Net.HttpWebRequest.GetResponse()     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.GetResponseHelper(WebRequest request, DataAdapterTimer dataAdapterTimer, DataAdapterCredentials credentials, Stopwatch timer, ExecWebRequestExceptionState state, String adapterName, Boolean isQuery)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.ExecWebRequestSync(XPathNavigator inputSubDOM, Boolean[] inputUseDataset, XPathNavigator resultsSubDOM, Boolean resultUseDataset, XPathNavigator errorsSubDOM, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, Solution solution, Document document, String name, Boolean isQuery, DataAdapterTimer dataAdapterTimer, DataAd...    1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25*    w3wp.exe (0x5FB0)                           0x0958    Forms Server                      Forms Services Data Objects       13zh    Exception    ...apterCredentials credentials, Boolean useDcl, Boolean useProxy, Boolean useSelf)    1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25     w3wp.exe (0x5FB0)                           0x0958    Forms Server                      Forms Services Data Objects       7tfk    Medium     Data adapter failed during OnLoad: The remote server returned an error: (401) Unauthorized.    1bf84c81-cb50-4514-85a9-a20b4a9d7b08
07/14/2010 16:45:22.25     w3wp.exe (0x5FB0)                           0x0958    Forms Server                      Forms Services Runtime - Data C    82fy    Warning     The following query failed: employees (User: test\testuser, Form Name: testForm, IP: , Request: http://test/_layouts/FormServer.aspx?XsnLocation=http://test/FormServerTemplates/testForm.xsn&SaveLocation=http://test/test+Forms&Source=http://test/test%2520Forms/Forms/AllItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:SLOForm:-myXSD-2010-04-17T19-29-38, Type: DataAdapterException, Exception Message: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized.)    1bf84c81-cb50-4514-85a9-a20b4a9d7b08

Data Connections

infopath form service error connecting to a web service