I just installed SQL Server Express 2005 on my newly purchased Vista Home Premium laptop. I’m running CF8 (awesome) and installed it with IIS which is what my servers run.
So, why wasn’t I able to set up a datasource within Coldfusion’s administration?
Matt Woodward’s excellent post got me close but for some reason my particular issue didn’t work. I noticed my IPAll TCP Dynamic Ports was something like 46987 and nothing was in my TCP Port setting…blank. It’s not apparent by looking at it but these fields are editable (is that a word?).
So after trying everything that Matt suggested, I deleted the 46987 port (yours will most likely be different), and I just typed in a port (1433) into the TCP Port option. I then restarted the SQL Server instance and tada! I am up and running.
Thanks Matt for getting me close. I hope this helps others.
Vince Collins
