database connection failure

[lilyaw111]

CFMX7, SQL SERVER 2005

SQL server database was migrated to a vmware server.

This is the error got when our network engineer changed the sql server IP address in the CF admin site:

Connection verification failed for data source:

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.

help appreciated.

[Adam Cameron.]

CFMX7 is pretty old... have you tried upgrading your JDBC drivers?

In what situations does this happen?  Every time you connect to the DB, or sometimes, or when running specific actions?

Have you googled the error message and worked through the mountain of discussion on the topic (granted, the signal to noise ratio is high, but there's a lot of stuff there).  If you haven't googled: you should be doing that first.  If you have: what have you tried?

Can you telnet onto the SQL Server box from the CF box using the IP address & port in question?  Can you connect to the SQL Server box from the CF box using SQL's client tools (like query analyser), using the same IP address and port AND the same credentials?

--

Adam

[lilyaw111]

Thank you for your response Adam, it turns out there was a firewall issue that caused the db not to connect to the cf server.