HTTPWebRequest timing out from database?

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  June 28, 2010 at 7:47 am

  #222681

  Okay, here's my scenario:

  I have a .NET CLR, which is a very simple class that simply does an HTTPWebRequest against a web site and receives the HTPPWebResponse, which is then returned.

  I've tested that the web site does in fact return the correct information when called from a web browser. It also returns the correct information when called from the .NET CLR. However, once it is deployed to the database, it simply times out.

  Can anyone provide any insight into why this is happening? Could it have something to do with an extra level of security that the database is requiring? The CLR functions correctly when used against other web sites - we have three which are being called, and two of those three are working correctly.

  Furthermore, the CLR was working 100% a week or two ago, and then suddenly this one server stopped responding.

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  July 3, 2010 at 7:12 am

  #1188513

  Hi kramaswamy

  Did you set database trust level to TRUSTWORTHY?

  Is CLR enabled on your server?

  Did you set your .NET assemblies permission level to "external"?

  I posted a blog, last year that shows how to retrieve data from a HTTP web response over SQL CLR:

  Query a web service with SQLCLR

  Greets

  Flo