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.