Jump to content
RESET Forums (homeservershow.com)
  • Install SQL Server 2008 on Windows Home Server 2011


    I'm a database guy, a nerd, and all around techy geek. I work in a Financial Reporting Department, but I think the name Fi-T better describes what we do. When I’m not building automated databases that write off the bad debt in our accounts receivable, I’m showing off the new media streaming features in WHS 2011 to my co-workers. So why not install SQL Server 2008 on Windows Home Server? After all with DE removed, it should now be able to run applications without a hiccup. Some might say just get SBS, but I still want the media features in WHS so here is how I installed SQL Server 2008 on the Release Candidate of Windows Home Server 2011 and combined the best of both worlds.

    Running the Setup.exe file generates this warning...



    We will keep that in mind and check windows update after the install to make sure all is ok. Here is the SQL Server installation Center...



    Clicking on installation starts the setup process...



    Everything checked out ok so let’s continue on...



    After you agree to the terms and conditions, the next screen will check the settings on your Windows Home Server...



    All looks good except the windows firewall, past experience tells me that the default firewall settings in Windows Server 2008 will not allow remote inbound connections to SQL Server until a few ports are opened up on the firewall. This is not a show stopper and is a simple fix that can be performed after the installation so let’s continue on and select the components of SQL Server that we want to install...



    Now select where you want the application to be installed. This is important since the databases, reports, and cubes that you build will be stored in the directory that you select here. If you plan on building huge databases, make sure you select a drive that you think can handle the data. You can change the location later (I believe) however it never hurts to set it up properly to begin with. Since I will not have huge databases, I will leave it on the C:\ (Where the WHS OS is installed)...



    Checking disc selections made in previous step..



    Next select how you want the various SQL Server Services to start when the Server starts up or re-boots...



    Select your authentication method for the Database engine (how you will login to the SQL Server)…



    Select Analysis Services authentication and users...




    If applicable select how Reporting Services will be installed on your Home Server. I chose SharePoint integrated mode since I want to try and set up a SharePoint site later. (It would be cool to set up a site so that my family can work on our family tree database).




    Continuing on with Error and Usage Reporting options...



    Validating Installation...



    Preparing to install...



    Just to show that we are in fact installing this on a WHS 2011 box, here is a picture of the installation progress in front of the WHS desktop...



    Post Install status report...



    Post Install Summary Screen...




    I went to windows update next to check for updates and to see if SQL Server 2008 SP1 is available for install... this is what was available...



    After installing all the updates I checked again for updates, but none were available and I didn't get the chance to install SP1, hmmm.... let’s see if it will work...


    Success! I am able to connect to the database on the WHS 2011 box!!!


    As we mentioned previously, to access your databases/cubes remotely in MS Excel you will need to open up a few firewall ports on your Windows Home Server.

    CAUTION: Opening ports could have un-wanted results, do so at your own risk.

    Connect to your WHS 2011 box via a Remote Desktop Connection, then click Start > Control Panel > Windows Firewall > Advanced Settings.

    Find and click on Inbound Rules > Click New rule > and the new inbound rule wizard opens up.

    Select the port radio button > click Next > select TCP > and in the Specific Local Ports box enter 1433 (this is the port that the SQL Server Database engine needs)> click next > Select Allow the connection > click next. In the profile section select the options that apply to your network setup > click next > give your rule a name and click finish. Now you can view database content from your WHS 2011 box on other computers!


    If you also want to connect to SQL Server Analysis Services via a remote connection, you will need to create an additional rule and open up port 2383 which is the port SSAS utilizes.


    This is what look at the Windows Firewall with advanced Security Snap-in. The first two Inbound rules “Open SQL Databases” and “Open SSAS” were created using the steps above.




    One final note, my WHS 2011 box has still not installed Service Pack 1 for SQL Server 2008, however I have not run into any problems as of yet. Hopefully this was informative to other database people out there, now if I could just install SharePoint 2010 on my WHS 2011 box without breaking the existing websites… that would be awesome!!!




    User Feedback

    Recommended Comments

    Nice write up. Looks like I will be installing SQL server this weekend. :) We just started using this at work, so having it at home will give me a chance to test some things.
    Link to comment
    Share on other sites

    Sweet instructions. My interest is in relation to the WHS2001 & SharePoint. I use a SharePoint wiki at work, and want to install it at home. The problem was, it needed SQL, which I had no experience in. Hopefully, I will be able to install both of these and start learning SharePoint. BTW: I have a TechNet subscription, which allows me to use this software for my training requirements :)
    Link to comment
    Share on other sites

    Nice clear instructions but I'd add just a couple of comments. Disable the "SQL Server Browser" service unless you want to broadcast to anyone listening that you have SQL running and which port to hack it on. When you connect you should specify the connection string and then there is no need for the browser service. Each SQL service should ideally be configured to use a seperate user account and none of these should ever be an administrator account. SQL Server doesn't need that level of permission and will allocate what is needed during the install process. Use a single account if you insist but make it a standard user account. Remember that any service configuration changes should be made using SQL Server Configuration Manager and this will modify security permissions and grant access as needed.
    Link to comment
    Share on other sites

    JVK Nice Post. I will try it. As for your wish to install SharePoint to the WHS without breaking the server web page, you will find in Chapter 13 of the new book "Windows Home Server 2011 Unleashed" Paul McFedries isbm-13: 978-0-672-33540-2, the directions for what you want as well as the web address for downloading "SharePoint Foundation". I believe it is a full license of SharePoint Foundation without expiration, but I havn't installed it yet myself. The key in restoring the broken web site is deleting the default SharePoint Web Application and creating another one. It's described in the book Chapter 13. The book also describes how to modify or add to the WHS 2011 web site, chapter 12.
    Link to comment
    Share on other sites

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

  • Our picks

    • RT6600ax tri-band Wi-Fi 6 router   Provide ultrafast and secure wireless connectivity to your home or office with support for the expanded 5.9 GHz spectrum,* combined wireless throughput of 6.6 Gbps, and a secure network infrastructure backed by the intuitive Synology Router Manager (SRM).
        • Like
      • 6 replies
    • I throw this out every once in a while.  Is anyone interested in writing up "semi-formal" reviews here on the forums?  I say semi-formal because they don't have to be pro level, just a good attempt at telling the story about the gear.  Something you have purchased lately.  You don't have to go buy stuff, just incorporate what you have already have purchased.  Hit me up with any questions.  You never know where it will lead!
        • Like
      • 5 replies
    • D-Link has dropped a couple of new products and additions to their lineup of smart home gear.  Hold on because there is a lot of gear!
      Let's start with cameras.  D-Link has new Wi-Fi cameras, the Full HD Pan and Tilt Pro Wi-Fi Camera (DCS-8302LH) and Full HD Indoor and Outdoor Pro Wi-Fi Camera (DCS-8526LH).  These are not just new, and good looking cams, they can now perform people detection and glass break detection.  The new cameras also feature expanded ways for customers to save video, including ONVIF Profile S, which enables custom storage and streaming options to personal NAS devices, built-in storage microSD capacity up to 256 GB, as well as free and paid cloud storage options. 

      This year's camera models include both an indoor and an outdoor model. The outdoor model features a spotlight and siren that can be triggered when motion is detected, deterring potential intruders. The indoor model pans around to give a full 360-degree view of any room and tracks motion. Both include two-way audio. 
      Full HD Pan and Tilt Pro Wi-Fi Camera is the model (DCS-8302LH), available in Q2, 2020, and retail pricing will be $99.99.
      Full HD Indoor and Outdoor Pro Wi-Fi Camera is the model (DCS-8526LH), available in Q3, 2020, and retail pricing will be $119.99.
      One of my favorite products is Wi-Fi.  D-Link has a whole lot of new products coming including Wi-Fi 6, Mesh, Alexa and Google Assistant integration, IFTTT, Parental Controls, and more!

      There are so many new SKU's that I can't make heads or tails of them!  I'm going to be speaking with D-Link more this week and will sort all of these out. I do want you to see all they are offering and what the release date and projected retail pricing will be.

      AC1900 Scalable Mesh Wi-Fi Router (COVR-1900-US), Q1 2020, $119.99
      AC1750 Mesh Wi-Fi Router (DIR-1750-US), Q1 2020, $99.99
      AC1900 Mesh Wi-Fi Router (DIR-1950-US), Q1 2020, $119.99
      AC1750 Mesh Wi-Fi Range Extender (DAP-1755-US), Q1 2020, $99.99
      AC1950 Mesh Wi-Fi Range Extender (DAP-1955-US), Q1 2020, $109.99
      Smart AX1500 Mesh Wi-Fi 6 Router (DIR-X1560-US), Q1 2020, $119.99
      Smart AX1800 Mesh Wi-Fi 6 Router (DIR-X1870-US), Q2 2020, $139.99
      Smart AX2400 Mesh Wi-Fi 6 Router (DIR-X2460-US), Q3 2020, $159.99
      Smart AX5400 Mesh Wi-Fi 6 Router (DIR-X5460-US), Q1 2020, $279.99
      AX1800 Mesh Wi-Fi 6 Range Extender (DAP-X1870-US), Q2 2020, $129.99
      AX1800 Whole Home Mesh System (COVR-X1872-US), QX22020, $269.99
        • Like
      • 0 replies
    • RESET Merch Shop
      Get ya Merch here!  I've created a T-Shirt shop with the famous RESET paperclip. I've pasted that clip on just about everything so you can wear it around town!  Cable bags, Coffee Mugs, T-Shirts, and more. 
      or you can get it it via
      Here is the main design.

      Below is a part of the order that I put in!  

      The Heather Grey above is the Extra Soft version and it is awesome.  I highly recommend the softness!    The "Chili Red" is the Tri-Blend and probably my favorite feel and color.

      This is the Zip-Up Hoody, Heather Indigo, Sponge Fleece, Men's, Large.  In my podcast I couldn't remember what style it was but it is Sponge Fleece. It's REALLY soft on the inside. Soft outside as well. The only problem is with the zip up hoody the logo is on the back. Regular hoody, it will be on the front.
      or you can get it it via
      Thank you for supporting this community. Everything you purchase will help keep the lights on the hard drives spinning.
      • 0 replies
    • OneDrive Personal Vault and expandable storage
      Microsoft's OneDrive has a few new features and options worth pointing out.  Personal Vault and Expandable Storage.
      Personal Vault is a protected area in OneDrive that can only be accessed with a strong authentication method or a second step of identity verification, such as your fingerprint, face, PIN, or a code sent to you via email or SMS. 
      Personal Vault gives you an added layer of protection for your most important files, photos, and videos—for example, copies of documents such as your passport, driver’s license, or insurance information—should someone gain access to your account or device.
      Plus, this added security won’t slow you down. You can quickly access your important documents, photos, and files with confidence wherever you are, on your PC, OneDrive.com, or your mobile device.

      Beyond a second layer of identity verification, Personal Vault also includes the following security measures:
      Scan and shoot—Using the OneDrive app, you can scan documents or shoot photos directly into your Personal Vault, keeping them off less secure areas of your device, like your camera roll.
      Automatic locking—No need to worry about whether you left your Personal Vault or your files open—both will close and lock automatically after a period of inactivity.
      BitLocker encryption—On Windows 10 PCs, OneDrive automatically syncs your Personal Vault files to a BitLocker-encrypted area of your local hard drive.
      Restricted sharing—To prevent accidental sharing, files in Personal Vault and shared items moved into Personal Vault cannot be shared.
      Taken together, these security measures help ensure that Personal Vault files are not stored unprotected on your PC, and your files have additional protection, even if your Windows 10 PC or mobile device is lost, stolen, or someone gains access to it or to your account.
      Expandable Storage
      If you are and Office 365 Subscriber you get 1 TB of OneDrive storage space with all the other Office goodies like Word, Excel, etc.  I know personally that I have gone over the 1TB limit and have always wanted to be able to add additional storage to my account.  Now you can!

      Pick and option and keep on hoarding, errr, I mean saving! Cancel anytime, upgrade at any moment.
      • 2 replies
  • Create New...