1 Physical server w sbs2011 - need to install SQL server

Posted on 2012-08-29
Last Modified: 2012-08-30
We have a physical server with SBS 2011 Standard PAO preinstalled - and we need to use SQL for a 3rd party shop software.
Can I install Hyper-v into SBS2011 and then 2008 with SQL Server in a virtual environment?
Question by:wallsjk
    LVL 20

    Assisted Solution

    by:Svet Paperov
    You will have to verify that it is in respect with the licence of SBS. I’ve never used SBS but I read some EE-expert opinion that this is not allowed by the SBS licence.

    If you are OK with that licence, you will have to purchase a new licence for Windows Server 2008 too.

    Besides that, if you have the Hyper-V as role to be added to the SBS and your server supports hardware virtualization (all recent servers should support it) that yes, you could do it.
    LVL 56

    Accepted Solution

    Unfortunately no. The hyper-v role is not supported on SBS and it does break several features. You want to install hyper-v on the physical server and then run SBS as one VM and your second server as a second VM.

    since you already have SBS installed, you will want to to  physical to virtual (P2V) conversion on a temp machine so you can get to a supported configuration. Several products can help you do this such as SCVMM, StorageCfaft ShadowProtect, or Acronis, among others.
    LVL 2

    Author Comment

    what about bypassing the vm scenario altogether and installing sql 2008 R2on the sbs2011 DC as is?
    LVL 56

    Assisted Solution

    by:Cliff Galiher
    you can, but you'll fight memory issues. Exchange wants memory. The monitoring database wants memory. Adding SQL,which wants memory, causes more contention. You'll take a significant performance hit. I personally would never do it, but technically it will work.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now