Cannot connect to SQL Server databases

[BennyLefave]

All of a sudden I can't connect to SQL server databases from my local machine.
The databases are on a web server. It just started happening, and I never had
a problem with it before. I can't connect to them in the coldfusion
administrator, and I can't connect to them using ODBC DSN's either. Has anyone
ever run into this before? I didn't change anything in the cf admin, and I
certainly didn't change any logins or passwords in SQL Server.

[pcbrown]

First thing I'd do would be to see if the DBA made any changes, and if not then I'd check with the Network Techs/Engineers.

[BennyLefave]

I administer the databases, and I didn't change anything. Just happened out of nowhere.

[cf_dev2]

Stupid question but SQL Server is running, yes? Also, what type of connection error are you getting?

[BennyLefave]

Yes, it is running. Here is what is weird about it. I have colfusion running
on the server. All the data sources connect just fine. I have coldfusion
running on my local machine, with the same datasources (for testing purposes)
but I can't connect, as of yesterday.

Here's the message I get when I try to verify the data source in the cf admin:

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

[cf_dev2]

Did you install anything new, apply updates, change firewall settings, etc?

Can you telnet into the database server? Example c:\ > telnet 127.0.0.1 1433
(server ip and port number)
Can you connect to the database using a command line tool like isql or sqlcmd ?

[BennyLefave]

Didn't change anything. One minute everything was fine and the next I couldn't
connect anymore. I can't telnet or ping or do anything like that because the
hosting company has that stuff turned off. If I try to telnet, it times out.
I've never used either sqlcmd or isql, but I'd venture to guess that I wouldn't
be able to connect using those.

[cf_dev2]

I think you'll need to ask the hosting company then.

[BennyLefave]

Yeah, you're probably right. Thanks for your help.

[setter1234]

I've been experiencing a similar problem. Everything was fine but I had to
reboot CF 8.01.
After the reboot all the datasources are very slow to respond and we get lots
of errors of the form :

Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from blah
Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from blah

Everything is working but very slow on database queries. This happened a
couple of months ago when we last
rebooted and then it went away.

Going to have a look for a new JDBC driver from adobe and see if that helps
....

[SafariTECH]

Check with the hosting company - they may have started implementing IPSEC in
order to control who/what is connecting to their SQL servers to squash a bit of
a hack that is running around right now.

Can you check the activity logs for the server itself? Are there a bunch of
errors noted at about the time the failure started? The SQL server could look
like it's running but supporting functions may be turned off disallowing
access. Rebooting or shutting down all the SQL services and turning them back
on may help in this case.

Those would be the 2 things I would look at for now.