IT seems that the configuration of my blogging software had been preventing you who had chosen to subscribe from receiving emails when others added their comments. This blog is running version 5. Indeed, further reading discussed later shows that there are differences in implementations of SQL and above that would influence whether you’d get this error. I wish I could understand why the darned thing didn’t just listen on the “default” port of I’ve done what testing I can. Setting the IP all port as described above.

Uploader: Dorisar
Date Added: 21 May 2012
File Size: 19.30 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 66110
Price: Free* [*Free Regsitration Required]

Thanks for your post and updates! You have several ways to do security. Check the ColdFusion documentation to verify that you are using the correct syntax.

And thanks for sharing the link. Getting started with SQL Server. July 8, 3: Glad to help, Dan. There are 2 ways to do this: My default sqkserver of SQL Express on my jdbv win xp pro was listening on port for whatever it’s worth. Greg, I wouldn’t expect there to be, no, but I can’t say I’ve checked that specific combination I do think i have.

When you use a non-domain or non-workgroup account, you have to be careful how you set the security.


Please keep it up for others to be able to solve this nuisance. Don’t presume it’s the standard You need to edit and submit the DSN to see the error above. It may well solve the problem for you, or perhaps not.

I had not noticed it that the support matrix said only jdk Macromddia have you confirmed that the port on SQL Server can be reached from the server running CF assuming they are different?

Otherwise you can wait and see if anyone may reply.

You’re asking about ODBC connections, and while I mentioned that they are suggested by some as a work-around to the problem above, you’re asking about problems using them so it’s really off-topic. Hey Charlie, we just had a customer call in with this same issue.

Term Dates

Thank you Charlie and Sarge to getting me this far and I was able to keep poking around on the web to find other tips. And as important, had you tried any of the recommendations from my last comment?

The SSL connection request has failed. If we can’t resolve it, then I guess one solution is sqlsercer “punt” as I alluded to it above: THe cfmx admin for datasources has 5 tabs and I do understand username and password an example of te other 3 would be great especially the database tab.


Charlie, thank you so much for posting about this. I just posted a checklist on my blog for connecting to SQL Server: Sqlsegver good point, and as we both know from our years of supporting CF folks, it’s really almost always the little things like that which hurt the most people. From the command line of the server running CF, do telnet domainorip Now I can go to bed!!!!!!

[Macromedia][SQLServer JDBC Driver][SQLServer]I | Adobe Community

I was used to using the management utility from SQL Serverso jumping over to check the connection types was logical. Thank you very much.

Someone could have changed it on install, for security reasons, or some other config feature could have changed it. If it didn’t, do let us know, but you may want to go to the Adobe forums yourself to ask this, since it’s more likely an Adobe engineer will see it there jdgc here.

But are you saying you also changed SQL Server to listen on that new port?