Trying to set up my brand new and ultra-clean dev box, running Win 8.1, SQL Server Express w/Tools 2014, CF 11. Having a really difficult time of it. Is there a step-by-step resource available. Are there common errors made in the SQL install that I may have made?
Also, when I last used CF Studio (a long time ago, yes...) there was a way you could view and manipulate your datasources/databases from within studio. I haven't been able to find that in CFBuilder... It was really useful, so I cannot imagine they would have killed it... so... where is it?
Finally... Any recommended reading for someone who's taken more than a decade off CF development? (and for that matter, programming of any sort)
Make sure SQL Server Express is installed on the default port (1433), otherwise you'll have to chase down the correct port. Make sure that TCP is enabled in SQL Server Configuration Manager (it's usually off by default for security).
You can use RDS in CFBuilder to browse/manipulate your database. There is an RDS Dataview that is part of the ColdFusion "Perspective". You have to enable RDS on your development server and then enter the correct credentials when you configure the server connection in CFBuilder. I personally don't like using it - I prefer to work in SQL Server Management Studio to write/test queries, then copy them into my code in CFBuilder.
As far as catching up, I'd steer clear of the ColdFusion Web Application Construction Kit (CF-WACK) books; while they introduce and explain the various features of ColdFusion fairly well, the approach to writing and organizing code is pretty archaic. I recommend Learn CF in a Week and Learn CFML with the ColdFusion Koans. I believe Online video tutorials & training | lynda.com has some ColdFusion tutorials as well.
Note as well you will need at least Coldfusion 11 Update 3 to use SQL Server 2014 as I don't think it was supported until that patch.
Not sure if the Coldfusion download on the Adobe website includes update 3 or not! The latest build is something like 11,0,03,292840
Yes, Adobe incorporated Update 3 into the latest installers. Good catch on the compatibility with SQL Server 2014 - somehow I completely missed that!
Thanks for the help everyone.
Part of my problem was that I set the SQLEXPRESS server to accept only Windows Authentication logins without providing CF Server the correct permissions. The directions I found are here:
I also tried this; I'm not sure if it was necessary or not:
At any rate, I've got everything working now and thanks again.
Yeah, the second link is what I meant by enabling TCP. And I forgot about the SQL Authentication vs. Windows Authentication issue - I hope it didn't take too long to identify that.
Glad you're up and running!