You only need MS SQL if you use it elsewhere, it isn't fundamentally needed for IIS or anything. If you do want a database to code against, I'd recommend the Developer version of MSSQL instead of Express. Either will work, but Express can be a bit funky with named instances and there are no performance monitoring tools with Express whereas with Developer you can look at execution plans and figure out what indexes you might benefit from, debug slow queries, etc.
.Net can live alongside CF happily. The one area of gotchas is A) bitness and B) handler mappings. I'm not sure about CF9, but CF8 has a limitation where you can only install the 32-bit version of Standard. If you want 64-bit, you have to go Enterprise. 32-bit Standard works just fine on a 64-bit Windows install but after you set it up, you have to go into the App Pool of your website in IIS and tell it to allow 32-bit applications otherwise the CF connector will fail with a 500 error. CF also tends to install a wildcard (*) handler mapping at the root level of IIS which means that any new websites you create will inherit from it. That wildcard mapping will send unknown requests through CF. If you are using pretty urls with .Net MVC or want static file handling, you'll need to remove the CF wildcard mapping on your .Net websites you create in IIS. My personal setup is: Win 7 pro w/ IIS 7.5 Railo latest .Net 4 Ruby on Rails 3 Scala (TypeSafe stack) Eclipse for CF and Scala editing Aptana for RoR and HTML/CSS/JS VS 2010 for .Net MS SQL 2008 Developer CouchDB Cheers, Judah On Wed, Nov 30, 2011 at 7:16 AM, Matthew Smith <[email protected]> wrote: > > well, i did it "to" my laptop this weekend. > > i've got enough hardware/memory to run it instead of a virtual machine i > guess, and don't game enough to worry about 1-2 fps because i have a server > or two running: > > so > > iis recommend install, check(?) > microsoft sql server data tools, database projects, check(?) (i still need > ms sql installed, right?) > > what else should i use? > > they have a couple of CMS in there, we are starting to go to > wordpress(finally!) but i am open to others. i LOVE CF, but a LOT of > people are running .net, and the devs i know personally are .net guys, so i > am open. > > visual studio 2010 SP1? maybe... just got CS 5.5 and still poking around > there. > > > > chedder > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:344246 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
