Https && Setting ServicePointManager.ServerCertificateValidationCallback

Hi,



In my CLR stored procedure, I made a https request. To by pass the security check, I change the property of ServicePointManager: ServerCertificateValidationCallback . But SQL server 2005 does not allow me to do this and gives me exception related to security.



It seems the CLR assembly does not have permission to set the property of ServicePointManager: ServerCertificateValidationCallback.



What kind of user should I use to run this stored procedure?

I already assign external_resource to the assembly in SQL server 2005.



The code:



ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(myCertificateValidation);

public bool myCertificateValidation(Object sender,
X509Certificate cert,
X509Chain chain,
SslPolicyErrors Errors)
{ return true; };



thanks,



Guangming