locked
SQL Server and Windows Home Server RRS feed

  • Question

  • I've read a couple of threads on this issue. I'm trying to do the same thing. I'm taking a certificate program as a Microsoft Database Designer and would like to install SQL Server 2008 Standard on my HP Media Server. I currently have 2 disks in the server a 500G and a 1T. I saw Ken Warren suggest putting the date on a disk outside the pool. But I'm not sure what that means or how to do it. I've also seen comments about not being able to install using Terminal Services. I started the install, but it then asked me to install some Windows Server 2003 patch and I wasn't sure if that would mess up WHS.

    Could really use some specific answers here.

    Scott<>
    MVP Access 2007-2009
    Saturday, July 11, 2009 1:46 AM

All replies

  • How much RAM do you have in the server, Scott?

    Here's my suggestion (and it's what I use on my production WHS):

    - add a disk to your server, but DON'T add it to the WHS storage pool. Log into the server via Remote Desktop and give it a drive letter
    - install Virtual Server 2005 SP2 on WHS
    - create a new Windows Server 2008 virtual machine, and use the new non-pool disk to store the virtual hard drive files and any DVD ISO images you're using
    - profit
    Tentacle Blog: http://www.tentaclesoftware.com/blog/
    WHS Disk Management: http://www.tentaclesoftware.com/WHSDiskManagement/
    Saturday, July 11, 2009 5:48 AM
    Moderator
  • Saturday, July 11, 2009 5:50 AM
    Moderator
  • Sam,

    Thanks, this sounds interesting. The only thing I'm not sure of is how to add a drive without adding it to the pool. I have a 320G external drive I've never used (I planned on using it to back up the WHS). Can I use that or would it be better to add an internal. I can probably get a 320-500G internat drive for about $75.

    Oh, by the way, I only have 512M of RAM.

    Scott<>

    Saturday, July 11, 2009 8:20 PM
  • Hi Scott,

    Don't use an external drive, use an internal one. As I said in the post above, you'll want to plug the disk in and then give it a drive letter in Computer Management - WHS will see this disk as "unknown" and may complain a bit about it on the Server Storage tab. You'll need to Remote Desktop to the server to do this, and you'll be operating outside the boundaries of what Microsoft supports.

    512 MB of RAM is far too small to run SQL 2008 with any sort of responsiveness, let alone a virtual machine. If you're comfortable working with hardware, I'd be upgrading that to 2 GB which will be much nicer. Lots of articles around on how to disassemble the MediaSmart to get at the RAM slot.


    Tentacle Blog: http://www.tentaclesoftware.com/blog/
    WHS Disk Management: http://www.tentaclesoftware.com/WHSDiskManagement/
    Saturday, July 11, 2009 9:37 PM
    Moderator