Here’s what you have to do before you can even start:
- Download and install Framework 3.5 SP1 (the installation takes seemingly forever: what is so complicated about extracting some DLLs?)
- Download and install Windows Installer 4.5
- Download and install PowerShell 1.0
- Download and run the Windows Genuine Product Validation Tool
- Reboot your computer twice
Of course, I appreciate that SQL 2008 Express has lots of good features—and the product is free, too. I’m grateful, don’t get me wrong. But what ever happened to “Express”? Installing SQL Express 2008 takes the best part of an hour!
Tell me your thoughts: do you plan to deploy Express 2008 in setup packages, or perhaps use SQL Server Compact instead?
3 comments:
Microsoft just needs competition :)
Never tried SQLite myself but you don't have to waste hours extracting some DLLs :)
System.Data.SQLite
http://sqlite.phxsoftware.com
If you can afford it or your company pays for it, I would recommend installing the SQL Server 2008 Developer Edition, creating both the default instance and a separate named instance called sqlexpress (to accomodate all the examples on the internet that connect to ".\sqlexpress").
Yes - good call. You need developer edition for the full tools (e.g., Profiler) and you need express edition to support user instances.
The gotcha is that you've got to install developer edition *before* installing sql express - otherwise you won't be able to install the full client tools!
Post a Comment