I'm calling a WCF service from a SQL CLR stored procedure. As a result I cannot use the configuration file generated by svcutil.exe for my SOAP web service. If I run the WCF service under the default .NET account in IIS I'm able to complete
the call without difficulty. When I run the WebService under a ServiceAccount I get the following error when I attempt to call the web service from the Sql Clr client:
System.ServiceModel.Security.SecurityNegotiationException: SOAP security negotiation with 'http://sdczeapwdcde09/TestClrService/Service1.svc' for target 'http://sdczeapwdcde09/TestClrService/Service1.svc'
failed. See inner exception for more details. ---> System.ComponentModel.Win32Exception: Security Support Provider Interface (SSPI) authentication failed. The server may not be running in an account with identity 'host/sdczeapwdcde09'. If the server is
running in a service account (Network Service for example), specify the account's ServicePrincipalName as the identity in the EndpointAddress for the server. If the server is running in a user account, specify the account's UserPrincipalName as the identity
in the EndpointAddress for the server.
The config file provides the UserPrincipleName that I need to&n
View Complete Post