Using Telnet to confirm communication with external server using SSL

Using Coldfusion 8 Enterprise on Windows 2008. I'm trying to connect to an instance of SQL Server 2008 through an encrypted connection but having no luck.

I'm trying to register a new Data Source in the Coldfusion administrator. The datasource if from a SQL Server 2008 box which only allows SSL connections.

I'm getting time out errors. So I tried to do away with the sql stuff and try to get as low level communication.

I'm trying to telnet into the SQL Server box but I'm getting this error msg: Could not open connection the host on port 1433: Connect failed.

If I have the servers info to connect via sql server login, how can I test this with telnet?

FastEddie___Asked:
Who is Participating?
 
phodges4Connect With a Mentor Commented:
a firewall could be blocking you that port inbound or outbound (locally or remotely) ..
or sql server could be down
or you could just have the wrong server info?

i would double check the server name and that you can resolve the domain .. then do a traceroute on the IP and verify you can get to the box ..
what happens if you just ping it?



0
 
phodges4Commented:
telnet SERVERNAME_OR_IP 1433
that should let you know if yoou can at least connect to the port
0
 
FastEddie___Author Commented:
Right I tried both but neither worked.  What are the possible causes for failure?
 
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
FastEddie___Author Commented:
I get Request timed out error when pinging the doman name and the ip.
 
0
 
FastEddie___Author Commented:
Their SQL Server box (the one I'm trying to hit) is using SSL so I didn't expect to be able to ping it.
 
 
0
 
phodges4Commented:
it's possible that ping will not work .. lot's of admins block that port ..
your next bet would be to try a portscan of that ip to see if can verify any type of connectivity ..
when you tried to telnet to port 1433 was the error you got back?
0
 
FastEddie___Author Commented:
How do I do the portscan?
The error I got back when telneting with port 1433 is: "Could not open connection to the host, on port 1433: Connect failed."
 
0
 
phodges4Commented:
hmmm .. from the sounds of if you can't hit that ip address .. if you were at least attempting to telnet to a physical machine you should at least get a connection refused unless the machine is down .. although this does not guarantee that the machine is down .. the firewall could just be ignoring your request .. what OS do you use?  windows?
0
 
FastEddie___Author Commented:
Thanks phodges4.
Yes, I'm using Windows Server 2003 and attempting to connect to an MS SQL Server 2008 box.

Port 1433 is open and I just put in a request for them to open up 443 just to see if that helps.
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.