ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ I'm facing a problem in accessing a WCF Service from a stored procedure in SQL Server 2008. The error obtained is as follows. An pointers to solve this issue wud be veryÃÂ helpful.
Msg 6522, Level 16, State 1, Procedure USP_CLR_ADD, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_CLR_ADD":
System.TypeInitializationException: The type initializer for 'System.ServiceModel.ClientBase`1' threw an exception. ---> System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.
The protected resources (only available with full trust) were: All
The demanded resources were: Synchronization, ExternalThreading
ÃÂ ÃÂ at System.ServiceModel.DiagnosticUtility.GetUtility()
ÃÂ ÃÂ at System.ServiceModel.DiagnosticUtility.get_Utility()
ÃÂ ÃÂ at System.ServiceModel.ClientBase`1..cctor()
ÃÂ ÃÂ at System.ServiceModel.ClientBase`1.InitializeChannelFactoryRef()
ÃÂ ÃÂ at System.ServiceModel.ClientBase`1..ctor()
ÃÂ ÃÂ at TestServiceClient..ctor()
ÃÂ ÃÂ at Channel.ServiceChannel.GetSum()
View Complete Post