Installing SQL Server 2008 Express
November 12, 2008
Installing SQL Server 2008 Express - you'd think it would be simple, but you'd be wrong! Here are the steps you will need to go through (on Windows XP at least!)
- Download and Install: .NET Framework 3.5 Service pack 1
- Reboot
- Download and Install: Windows Installer 4.5 Redistributable
- Reboot
- Download and Install: Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139)
- Reboot
- If you have Microsoft SQL Server Management Studio Express installed, then you need to uninstall it.
- Reboot
- Download and Install: Microsoft® SQL Server® 2008 Express with Tools
- Reboot (spotted a theme yet?)
Now you need to set SQL Server 2008 Express to accept connections from ColdFusion by allowing connections from TCP/IP (which is disabled by default).
To enable it...
- go to Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.
- In the SQL Server Network Configuration node, click on the Protocols for SQLEXPRESS node.
- Click on TCP/IP, and enable it.
You should now be able to connect on port 2775. It is a good idea to lock TCP/IP connections down to one port (for security or to allow another instance of SQL Server to run). SQL Server 2000 used port 1433, so I like to do the same for 2008. To set the port, click on the "IP Address" tab and clear the value for “TCP Dynamic Ports” and enter the port you want to use in the “TcpPort” box. You will need to use the same port when setting up your datasource in the ColdFusion administrator.
Important: You will need to restart the SQL Server Service for it pick up your changes, which you can do from the SQL Server Services node in SQL Server Configuration Manager or from the Services Control Panel.
- Posted in:
- SQL
- ColdFusion
6 comments
Leave a comment
If you found this post useful, interesting or just plain wrong, let me know - I like feedback :)

Surely the installer would detect what's missing from your Windows installation and automatically offer to download and install the missing components for you? Or perhaps MS assumed SQL users don't need so much hand holding? Well we don't, but it's more of a convenience feature if it was to have it.
Comment by Gary Fenton – November 12, 2008
The installer does check that you have the required elements, however it just shows a report saying it failed with no useful links to the download. It also doesn't check for all requirements in one go!
Comment by John Whish – November 12, 2008
Comment by Tariq Ahmed – November 22, 2008
Comment by John Whish – November 22, 2008
I have donw all steps (with the reboots)
when I install the Microsoft® SQL Server® 2008 Express with Tools (I have it as an exe file downloaded from the link you provided) it extracts all files and opens the admin window. When I try to install a new SQL database it runs and gives an error saying that reboot required and failed. I rebooted several times and no luck.
Any idea?
Regards
Comment by Mahmood – December 21, 2008
Comment by John Whish – December 23, 2008