How do we get sql server to send clr request to web server

We have Several CLR stored procedures that we run from SQL Management Studio and within Jobs that are scheduled to run at specific times. The CLR's create a Web Request that should be going to our Web Server; however they time out with a message that they went to our old Proxy Server which is no longer in service. We have found that if we bring the OLD Proxy Server back online then that fixes the issue. The Requests that are being created are ultimately reaching out to External Web Service. I have already verified that there are no Proxy Setting that I can find in the SQL Server submitting the requests.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

srutzky commented · Oct 30, 2015 at 08:37 PM

Under "Internet Options" on that server there is no routing of requests through a proxy server? How did you verify the proxy settings? Also, is there any mention of the proxy server in the .NET code for that SQLCLR stored procedure?

0 ·