I am invoking a web Service call inside SQL Clr table valued function (C#). When the sql function is invoked following error is received
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
The web service url used is https and for SSL 3 i have explicitly used following directive in the C# code "ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3;"
When the exact same C# codde is used in console application and invoked it works fine but from the SQL server its failing any help is greatly appreciated.