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


    Dave
     Share

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

    clip_image001

     

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

    clip_image002

     

    Clicking on installation starts the setup process...

    clip_image003

     

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

    clip_image004

     

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

    clip_image005

     

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

    clip_image006

     

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

    clip_image007

     

    Checking disc selections made in previous step..

    clip_image008

     

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

    clip_image009

     

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

    clip_image010

     

    Select Analysis Services authentication and users...

     

    clip_image011

     

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

     

    clip_image012

     

    Continuing on with Error and Usage Reporting options...

    clip_image013

     

    Validating Installation...

    clip_image014

     

    Preparing to install...

    clip_image015

     

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

    clip_image016

     

    Post Install status report...

    clip_image018

     

    Post Install Summary Screen...

     

    clip_image020

     

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

    clip_image022

     

    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!!!

    clip_image024

    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.

     

    clip_image026

     

    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!!!

     

    jvk

     Share


    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

    • 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
      • 3 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. 
       
      https://reset.threadless.com/
       
      or you can get it it via
       
      https://reset.fm/store
       
      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.
       
      https://reset.threadless.com/
       
      or you can get it it via
       
      https://reset.fm/store
       
      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.
      • 1 reply
    • Ubiquiti adds new items to the Unifi Line including UAP Flex HD and the Unifi Dream machine
      Ubiquiti has been busy.  There area ton of new items to recently released and I'm going to share two of my favorites.
       
      The UAP Flex HD and the Unifi Dream machine. The Flex HD is a mouthful of descriptors like most of UI gear is.  It's a 2Ghz 2x2 MIMO, 5GHz 4x4 MU-MIMO, POE, Indoor/Outdoor, multi mount, mesh point that is no bigger than a can of Coke.

       
      You will still need the Unifi controller although you can configure it with basic functionality with the Unifi App.  I've always found it's best to configure with your controller and then use the app as an add-on.  There are several mounting options that include sitting it on a shelf! That is something that Unifi has not had before unless you count the ceiling AP I have awkwardly mounted placed on top of a few books.  It can be found on the Unifi store for $179.
       
      https://store.ui.com/collections/wireless/products/unifi-flexhd
       
      The Dream Machine is an altogether different beast that I hope lives up to its naming.  This is the gateway drug, for lack of a better term, to the Unifi world.  The starter kit.  It is an Access Point, Gigabit Switch, Security Gateway, and the Cloud Key all in one package.  The latter being the most significant as this is something that has deterred new users from getting started with Unifi.  Requiring new users to purchase a $100 item just to run the AP's has been somewhat of a roadblock in the past.  Granted, that is improving every year with the ability to run it in the cloud, on a NAS, a Pi, Docker, MacOS, and of course Windows, it is still a barricade to getting up and running when manufacturers such as Eero offer simplicity in an app.
       

       
      The switch includes 4 LAN Ports and 1 WAN port.  All of which are Gigabit and security services such as IPS are rated at Gigabit speed. It's $299 in the Unifi store but I'm unsure how nicely it will play with other Unifi gear.  This may be a nice "first AP" with its built in Cloud Key if you can add additional units or other Unifi access points.
       
      https://store.ui.com/collections/routing-switching/products/unifi-dream-machine
      • 4 replies
×
×
  • Create New...