If you are one of the millions of users who just use Windows Home Server to remotely access your data, stream Media, and Backup your PC’s then there really is no benefit in installing this particular application. However if your one of those Hobbyist or IT Tinkers who want to get the most out of their Home Server beyond the scope of what it was designed to do then this maybe exactly what you need.
Since this Version’s underlying code is Windows Server 2008 R2 there is just so much that can be done to get some of those Enterprise applications and just make them useful for your family’s or small business’s every day needs for example like WSUS and SharePoint. These programs usually require a Database application server (Which usually comes with a lite version that is a bear to manage) like SQL but under normal circumstances obtaining a professional version to manage these Databases are a bit pricey.
With SQL 2008 R2 Express with Management Tools you can get the power of their Microsoft Full fledge version but on a much smaller scale (Each DB instance has a 10GB limit), the best part it’s free.
– A Windows Home Server 2011 with at least a Intel Dual Core or equivalent and 3GB’s of system Memory.
– Download the 64 bit installer of the SQL 2008 R2 Express with Management Tools. (The software is free but you will most likely have to register with a Windows Live account). https://www.microsoft.com/betaexperience/pd/SQLEXPDBMT64/enus/
– Remote Desktop or Keyboard, Mouse, and Monitor.
Before You Start
Do a backup of your system drive before you begin the installation just in case the install does not go as planned and the registry somehow gets damaged.
The How to information is intended as a guide or helping resource to those who are trying to install SQL 2008 R2 Express with Management Tools on their Windows Home Server 2011. There is no 100% guarantee that this will install correctly the 1st time installing this application on your home server and there is the slight chance of registry damage to your home server Operating System. I assume no responsibility for any consequences of the install and the user will assume the full risk of any adverse effects of a bad installation.
1) Double click on the SQL 2008 R2 express installer and wait for it to unpack.
2) Once the SQL 2008 R2 express opens to the Main setup scree click on the 1st choice “New installation or add features to an existing installation”.
3) Let the Setup Support Rules complete its initial check.
4) Check the box “I accept the license terms” and click “Next”.
5) Let the Setup Support files complete its initial check.