EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / Coldfusion MS SQL problem

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Coldfusion MS SQL problem -- page: 1 2

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

donboe
11-10-2004 @ 1:17 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 474
Joined: Nov 2004

I'm desperate Confused and hope somebody here can help me out.

I use CFMX and I created a data source for a remote Microsoft SQL database. I can access the database using MS Access on my local computer but trying to connect to it with Coldfusion gives the following message:

Connection verification failed for data source: HellWebData []java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I used the folowing data to establish the conection:
COMMENTED OUT YOUR SQL INFORMATION, THIS IS A SECURITY RISK FOR YOU AS YOU ARE GIVING YOUR SA PASSWORD. (Pablo)

Can somebody please tell me how I can solve this problem. Question

Thanks in advance

This message was edited by Webmaster on 11-10-04 @ 7:05 PM

Webmaster
11-10-2004 @ 7:09 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

I commented out your information above due to security reasons.

I did however try to connect and it did so just fine. are you behind a firwall or anything like that?

Thanks,
Pablo Varando
Team Macromedia Member
=====================================================

donboe
11-11-2004 @ 12:36 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 474
Joined: Nov 2004

Hello Pablo,

Thanks for your respons and kindness, but that's how desperate I am. There where more people who asked us about that firewall. When, however, we asked that question to the company where we have our serer, they told us that it is a standard configuration without a firewall.

Another person though suggested the following:
quote:


Just ask your network admin to allow http access on port 1433 to the IP address of your server.


Is this something you recognize or that you are familiar with?

Thanks in advance,
Donald Boers

maquiladoras
11-15-2004 @ 3:28 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

I think what the guy was saying is one of the machines (most likely to be the CF server) has some sort of firewall or IPSEC in place.

for instance most webservers dont have any need for outgoing ports, so for security reasons they would block most outgoing ports to stop certain worms and virii.

this can be done through Windows 2000/2003 or Linux locally or it can be through a firewall

what needs to happen is the CF machine needs to have outgoing port 1433 open and the SQL machine needs to be able to accept 1433.

It seems that the SQL server is open to anyone on that port, so you can easily rule that one out.

What i would do is either you or the support team SSH/Telnet to the CF machine and do a telnet to port 1433 to make sure that you can establish the connection, if you can then you have just ruled out the possibility of communication errors between the two and the fault would seem to rest in the connection parameters in the CF Administrator.

-
"There is no justice, There is Just Us"
-

donboe
11-16-2004 @ 1:24 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 474
Joined: Nov 2004

Hi,

Thank you for your responce. I'm renting a server and am not that familiar with what you said. Is threre any way you can explain to me how I can SSH/TELNET to a certain server. I would really appreciate it if you can so that I dont have to depent on other people all the time?

Thanks in advance

This message was edited by donboe on 11-16-04 @ 1:28 AM

maquiladoras
11-16-2004 @ 9:07 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

telnet/ssh is just really a remote command shell, if its a shared server most likely you wont be allowed to do that because its giving you pretty much full control of the machine.
If you rent it though and they let you install anything and controlling it, then you will be able to, the best thing to do is first of all ring your hosting company and ask if you are allowed to telnet/ssh on to your machine.

If they say yes, you are best to download a program called Putty (http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html)

all you do is open it up, put in your machines host name or ip address, connect and then enter your username or password.

from there just telnet to your SQL Server
(telnet <ipadrress> <port>) and then if its succesful you will know that your web server can connect to your SQL Server

-
"There is no justice, There is Just Us"
-

donboe
11-16-2004 @ 10:21 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 474
Joined: Nov 2004

Hi maquiladoras.

Thank you for your responce! We are aloud to control the server ourself. We have the application SSH Secure shell what we use to upload. Is that the same as Putty?

Thanks in advance,
Donald

maquiladoras
11-16-2004 @ 10:24 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

SSH is a server, so is telnet, its just that SSH is secure, you can connect to it via an FTP client or something like Putty, all Putty is is a terminal, a front end, something that connects to the server.

so if you download putty, and SSH to your server, you will see what i mean.

-
"There is no justice, There is Just Us"
-

donboe
11-16-2004 @ 10:46 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 474
Joined: Nov 2004

Thanks again. There are two Putty exe files for XP Putty.exe and Puttytel.exe! Which one should I dowwnload?

Regards,
Donald

maquiladoras
11-16-2004 @ 10:51 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

-
"There is no justice, There is Just Us"
-

PAGE: 1 2

Website Designed and Developed by Pablo Varando.