question

danjohnson avatar image
danjohnson asked

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.
sql server 2008 r2proxy
1 comment
10 |1200

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

srutzky avatar image srutzky commented ·
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 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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