A connection attempt failed because the connected party did not properly respond

Sep 1, 2015 at 5:41 PM
Hi there,

I'm getting the following error when running the test function:
SELECT * FROM ProcessAddress('506 Fourth Avenue Unit 1', 'Asbury Prk, NJ', NULL)

Could you please help me solve this:

Msg 6522, Level 16, State 2, Line 58
A .NET Framework error occurred during execution of user-defined routine or aggregate "ProcessAddress":
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 23.249.225.87:80
System.Net.Sockets.SocketException:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
System.Net.WebException:
at System.Net.HttpWebRequest.GetResponse()
at YAddressSqlFunction.CallYAddress(String sAddressLine1, String sAddressLine2, String sUserKey)
at YAddressSqlFunction.YAddressResults..ctor(String AddressLine1, String AddressLine2, String UserKey)
at YAddressSqlFunction.InitMethod(String AddressLine1, String AddressLine2, String UserKey)
.
Sep 1, 2015 at 7:34 PM
Your server needs to be able to access Web API at the IP address mentioned in the error message, and it looks like it cannot. The easiest connectivity test is to open a browser on the machine running your SQL server and see if you can reach http://www.yaddress.net.
Sep 9, 2015 at 10:13 AM
YuriDiomin wrote:
Your server needs to be able to access Web API at the IP address mentioned in the error message, and it looks like it cannot. The easiest connectivity test is to open a browser on the machine running your SQL server and see if you can reach http://www.yaddress.net.
Hi Yuri,

Thank you for that, it seems to have worked! :-)