How To's & GuidesInstalling SQL 2008 R2 Express with Management Tools on...

Installing SQL 2008 R2 Express with Management Tools on Windows Home Server 2011


- Advertisement -

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).

– 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.

Installation Instructions

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.


John Keller
John Keller
John has been in the IT profession for over 20 years along with being certified in both Comptia Security + (2008 edition) and a MCP (Microsoft Certified Professional) on Both Windows XP & Server 2003 Administration, He currently works as an Windows System Administrator for Northrop Grumman in the Greater Los Angeles Area and manages 3 Windows Active Directory Private Networks (Two 2008 R2 and One 2012 R2) along With 2 VMware EXSI 5.5 Servers in the US. He has been an avid fan and follower of Windows Home Server (Now the Essentials Role of Windows Server) and Visualization Since 2009. He is currently trying to exploit the full potential of Microsoft's Windows Server Operating System to the Home & Small to Medium Business Community along with the power of Visualization. When not being a Nerd and a Geek he likes to watch Movies, Read Comic Books, and most importantly spend time with his family.


  1. Thanks Guys, appreciate all the help and support from the both of you. Working on My Next one now

Comments are closed.

Stay connected



You might also likeRELATED
Recommended to you