CLR SSL Problems - Unable to connect to the remote server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cube - 01 Jul 2009 17:38 GMT

I have developed a set of CLR stored proc's that need to connect to a remote
server
over SSL. I have tried over HTTP and it all works fine, but when I try over
HTTPS. I receive the error: "Unable to connect to the remote server --->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it XXX.XXX.XXX.XXX:80".

Has anyone encountered this issue? Is there somewhere I can install the SSL
Cert to resolve this issue? I've tried to download it into the Trusted Certs
store but with no success?

Reply to this Message

Peter DeBetta - 01 Jul 2009 19:25 GMT

Could you send your code so we can see exactly what you are doing?

> I have developed a set of CLR stored proc's that need to connect to a
> remote
[quoted text clipped - 11 lines]
> Certs
> store but with no success?

Reply to this Message

Cube - 01 Jul 2009 19:38 GMT

Thanks Peter, I resolved this issue. According to the web service provider
the issue was related to load balancing and that the load balancing servers
behind the firewall were resolving the url to the standard port 80. There was
a parameter which allowed me to set the url explicitly (without the ?wsdl)
and this did the job nicely. Thought I'd share it with you as it could leave
a few scratching their heads ;)

> Could you send your code so we can see exactly what you are doing?
>
[quoted text clipped - 13 lines]
> > Certs
> > store but with no success?

Reply to this Message

Peter DeBetta - 02 Jul 2009 18:22 GMT

Appreciate the follow-up!

> Thanks Peter, I resolved this issue. According to the web service provider
> the issue was related to load balancing and that the load balancing
[quoted text clipped - 24 lines]
>> > Certs
>> > store but with no success?

Reply to this Message