Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set up and use sql server 2005 web service

Status
Not open for further replies.

seaport

MIS
Jan 5, 2000
923
US
I created a web service on a SQL Server 2005 and a testing asp.net web application on another computer (within the same LAN) to use that web service. The web application works fine. However, after I published/copied the web application to a web server, which is outside the LAN, I got the following error and trace.

*************************
[SocketException (0x274c): 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 64.60.100.18:2046]
System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) +1073657
System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +33
System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +217

******************************

As I understand, this error occurred even before the web application supplied the network credential to the sql server. In my testing environment (within the LAN), if the web application tries to query the sql server without the code supplying credential, the returned error is 401 - Unauthorized.

By the way, I was able to retrieve the wsdl info of that service outside the LAN.

Any idea?

Thanks in advance.

Seaport

 
One correction,

On a workstation outside the LAN, I was able to retrieve wsdl page using Firefox, but not using IE (I got the error 501/505).

Within the LAN, I could access that info using both Firefox and IE.

Seaport
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top