Hi Everyone!
The short version of my trouble is that I have forms that are trying to call a web service through the forms services web service proxy but they are being denied access to the web service because the proxy is not properly authenticating with the web service. I understand that the proxy is supposed to authenticate using the MOSS service account but it is trying to impersonate the logged on user which doesn't work because I don't have Kerberos enabled. I just want to make a secure web service connection without having to enable Kerberos or SSO.
Here is the long version: I created several web enabled forms that use a web service for querying and submitting data. They were all working fine except that when I got ready to move them to production I realized that I had left anonymous access enabled for the web service the whole time and my client frowns upon anonymous access in production. Go figure! I then changed the IIS settings for my web service to Integrated Windows Authentication only and made the appropriate changes in the web.config to only allow authorized users. The result is that my forms work when I am logged in locally to the MOSS server, but if I access them from a different computer it becomes a double hop scenario and the form calls the web service without authenticating and is denied access. I just want the form to use the MOSS service account to call the web service and after doing some research it appears that the Forms Service Proxy is designed to allow me to do just that. I enabled the Forms Service Proxy in SharePoint Central Admin and in all my UDC files, but my forms are still trying to impersonate my account when they call the web service instead of using the MOSS service account as I would expect. I have verified this by checking the IIS logs. I know that the forms are using the proxy because if I disable the proxy in SharePoint Central Admin I receive errors in the SharePoint logs saying that an exception occurred in the Forms Service Proxy. That error goes away when I re-enable the proxy. I know SSO is another option but I don't want to use it because I understand that the users will have to enter their passwords the first time they use it and that is really not an option.
Does anyone have any ideas of how I can troubleshoot this? Please help!
Russ