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

6) At this point you can either accept the default selections by clicking “Next” or you can change the directory paths below to another hard drive letter to save room on your system partition, click “Next” when finished.

7) On the “Instance Configuration” page this is the chance to name your SQL instance. It can be any combination of letters and numbers only (No spaces) or you can accept the default name. Also you can change the directory paths below to another hard drive letter to save room on your system partition if so desired, click “Next” when finished.

NOTE 1: If you decide to enter your own instance name and put anything other than letters or numbers (No Spaces) you will receive the below error.

8) On the “Server Configuration” page click on the “Use the same server account for all SQL Server Service” on the middle of the right side half of the below Server Configuration Page.

9) When the SQL Server credential box comes up click on the “Browse” Button.

10) In the “Select User or Group” box put the name of the account you want to use as a service account for your SQL Server instance. (Since Home Server can only have up to 10 user accounts, 12 if you count the Administrator & Guest Account. I would recommend just using the built-in “Administrator” account since you are then not taking out of your pool of 10 user accounts allowed and the likely hood of changing the password on the “Administrator” account is very small.)

11) Type the name of the user account you have decided to use (In this case we are using “Administrator” account, whatever account you decide to use insure that it has the administrative privileges necessary to do the job) then click the “Check Names” button to verify the account is good, Then click “Ok”.

12) You will then be prompted to put the password of the account in the below, put in the password and click “Ok”.

NOTE 2: For those Windows Administrators out there as we all know this would be considered a security risk not having specific service accounts for the different SQL instance Databases. However this being a Home/Small business environment and being short on account resources this is more practical for this kind of environment.

13) Once the “Server Configuration” page returns click “Next” to continue.

14) On the “Database Engine Configuration” page in the “Account Provisioning” tab insure that “Windows Authentication” is chosen and that were it says “Specify SQL Server administrators” your account that you have chosen is highlighted.