I'd credit the author but the original link wouldn't work for me and i just copied the text out of the document and made my own. It should be on the Technical forum on SupportNet though.
Click on Installation in the left hand menu and then select the first option New SQL Server stand-alone installation. The SQL Server 2008 setup process will start.
Now follow the instructions on page 12 of Capita’s Migrating SIMS to SQL2008 documentation, part 11. up to part 17 Feature Selection page. This is where SQL2008 Express differs from SQL Server.
The Capita help-desk recommendation is to tick the following:
- Database Engine Services.
- SQL Server Replication.
- Full-Text Search.
- Analysis Services
- Client Tools Connectivity.
- Integration Services.
- Client Tools Backwards Compatibility.
- Client Tools SDK.
- Management Tools - Basic
- Management Tools - Complete
It's optional if you wish to install the Reporting Services.
On the Instance Configuration page, change the Named instance to SIMS2008. Your existing SIMS SQL instance is probably called SIMS2005 (see the installed instances panel). Click Next.
The Server Configuration window will be displayed. It should look similar to the following. If so click Next.
On the Analysis Services Configuration window, ass you users for which you want to give access. Click Next.
Now follow the Capita documentation from section 22 on page 17, “Database Engine Configuration”.
Once the installation has complete, the Installation Process screen should look similar to
Click Next, SQL Server 2008 has now been installed.
At this stage yo can run the SIMS SQL Migration Utility.