CFMX v 8 to SQL Server 2008 R2

We are connecting from ColdFusion v 8 to SQL Server 2008R2 where tcp/ip has been enabled.  We cannot create the datasource using the Microsoft SQL Server Driver in CF as we receive this error.

Connection verification failed for data source: dbname
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.
jlshakalSr Systems AdministratorAsked:
Who is Participating?
 
Brijesh ChauhanConnect With a Mentor Staff IT EngineerCommented:
Check out your windows EVENT logs as well, they might have the reason for the error,

here is a similar issue posted

 http://mayoorathen.blogspot.com/2010/08/coldfusion-sql-server-2005.html...
0
 
RickEpnetCommented:
You need to make sure there are no firewall rules on either server preventing the connection we use SQL 2008 R2 not problem with CF8
0
 
jlshakalSr Systems AdministratorAuthor Commented:
We've been able to work around it with the ODBC Socket, however, some of our applications require the SQL Server driver.  Checking firewall rules now.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
jlshakalSr Systems AdministratorAuthor Commented:
Firewall is OFF on both servers
0
 
Jones911Commented:
Are you sure your putting in the right IP address of the SQL server?
0
 
RickEpnetCommented:
You should not need OBDC.

Are you running 64bit on the SQL 2008 R2?

Do you have 32Bit Clients like you see in the screen shot?
3-21-2011-2-55-07-PM.jpg
0
 
jlshakalSr Systems AdministratorAuthor Commented:
@RickEpnet - Yes 64bit on the SQL Server, and 32bit SQL Native Client just as your graphic indicates.  
0
 
RickEpnetCommented:
When you say you enable TCP/IP have you enabled it on both standard and 32bit?
0
 
jlshakalSr Systems AdministratorAuthor Commented:
In the SQL Server Configuration Manager -
SQL Native Client 10.0 Configuration (32bit)
 Client Protocols TCP/IP Enabled
and under
SQL Native Client 10.0 Configuration
 Client Protocols TCP/IP Enabled

0
 
Jones911Commented:
Are you sure your putting in the right IP address of the SQL server?

Also after enabling TCP/IP have you rebooted?
0
 
RickEpnetCommented:
Here too? You can go back in and disable any you do not want once you get it working.
3-21-2011-3-18-47-PM.jpg
0
 
jlshakalSr Systems AdministratorAuthor Commented:
@jones911 - used the name of the sql server, then recreated the datasource using the IP address and got the same results.  The servers have been rebooted serveral times.  We've been live for months, but are running out of options since sql 2005 is desupported next month.
0
 
jlshakalSr Systems AdministratorAuthor Commented:
@RickEpnet - on those properties only IP1 and IP2 show Enabled.  I went and marked them all YES, but have to wait to restart the services.  
0
 
jlshakalSr Systems AdministratorAuthor Commented:
@RickEpnet - same error even after changing all IPs to Yes / Enable and restarting the services.
Connection verification failed for data source: nexgen1
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.

0
 
Jones911Commented:
Can you ping the server?  Does the DB username exists?  Try a SA user/pass?
0
 
RickEpnetCommented:
Have you applied all the patches to the CF machine. I am talking about Coldfusion Patches?
0
 
jlshakalSr Systems AdministratorAuthor Commented:
@Jones911 - the server can be pinged - the DB is valid, I used our SA user/pass and same error.  as noted in prior comment, we are using odbc socket, but appears some of our application require the sql server driver.  that's where we are failing at connectivity.
0
 
Jones911Commented:
Is it an issue with a names instance of the database?
0
 
RickEpnetCommented:
I am kind of at a loss. Not sure if the updates will help.
0
 
jlshakalSr Systems AdministratorAuthor Commented:
the issue is with the default instance - not named instance.  no firewall rules, tcp/ip is enabled, SA accounts can login via odbc, but not w/coldfusion using sql server driver.  very odd.
0
 
RickEpnetCommented:
I too am using the default instance.
0
 
_agx_Commented:
Shot in the dark, but check *all* of your CF logs. There may contain more detail about the error.

Also, have you tried using a different driver instead, such as the MS Driver or jTDS?
MS Driver: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
JTDS: http://jtds.sourceforge.net/ 
0
 
RickEpnetCommented:
You had encryption turned on in the SQL server?
0
 
_agx_Commented:
So .... what was the problem?
0
 
RickEpnetCommented:
No just unusual. Is you SQL server exposed to the internet.
I am so glad someone thought to post that for you. I am just sorry I did not think of it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.