Solved

Using Telnet to confirm communication with external server using SSL

Posted on 2010-09-23
9
853 Views
Last Modified: 2012-05-10
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?

0
Comment
Question by:FastEddie___
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 2

Expert Comment

by:phodges4
ID: 33749312
telnet SERVERNAME_OR_IP 1433
that should let you know if yoou can at least connect to the port
0
 

Author Comment

by:FastEddie___
ID: 33749351
Right I tried both but neither worked.  What are the possible causes for failure?
 
0
 
LVL 2

Accepted Solution

by:
phodges4 earned 500 total points
ID: 33749363
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:FastEddie___
ID: 33749417
I get Request timed out error when pinging the doman name and the ip.
 
0
 

Author Comment

by:FastEddie___
ID: 33749420
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
 
LVL 2

Expert Comment

by:phodges4
ID: 33749436
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
 

Author Comment

by:FastEddie___
ID: 33749488
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
 
LVL 2

Expert Comment

by:phodges4
ID: 33749574
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
 

Author Comment

by:FastEddie___
ID: 33754275
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ColdFusion 9 CF Administrator and Request Filtering 3 39
Job - date manual 1 42
query output (script) from a stored procedure 4 38
Linked Server - SP with Param to VIew 7 22
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question