 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Database Access / August 2008Cannot connect to SQL Server databases
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. 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. I administer the databases, and I didn't change anything. Just happened out of nowhere. Stupid question but SQL Server is running, yes? Also, what type of connection error are you getting? 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 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 ? 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. I think you'll need to ask the hosting company then. Yeah, you're probably right. Thanks for your help. 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 .... 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.