sql server not supported on sbs 2008 r2 error

Posted on 2012-09-06
Last Modified: 2012-09-16
I am trying to install Sql Server 2008 R2 on a VM with SQL Server 2008 R2 and I am getting a  message failure that SQL server is not supported on this version of the OS.

I started an install yesterday that i had to abort and reattempted this install today and that is when i got this message - i was able to get past this point of the install originally.

I uninstalled from the control panel the partial install also.

Question by:wallsjk
    LVL 5

    Expert Comment

    Which version of SQL you trying to install; Sounds like Standard SBS to me...

    You'll need an SBS server O/S to install SQL 2008R2 SBS, or at least meet the simular critea in your domain:

    Windows ServerĀ® 2008R2 Standard (must be configured in a small business domain configuration).  To install this product on Windows Server 2008R2 Standard edition, the server must be joined to a Small Business Server 2008R2 domain or a domain that has Active Directory configured in the following way:
            It must be joined to a domain where a single server in the domain must contain all the flexible single master operations (FSMO) roles and is the root of the Active Directory forest,
            The domain cannot have trust relationships with any other domains,
            The domain cannot have any child domains, and
            The sum of user and device licenses in the domain cannot exceed 75.
            The customer may not run instances of the server software, separately licensed or otherwise, at the same time in another operating system environment within the same domain.

    LVL 2

    Accepted Solution

    it is the SBS 2008 SQL Server R2 on SBS 2008 R2 ( from the SBS 2011 Premium Addon).
    I found on another site the following possible solution that i will try as soon as updates finish.

    SOLVED Re: Sql server 2008 will not install on extra Windows 2008 server that comes with SBS 2008

    That did it. It works!!!!!!
    I was logging in as the adminstrator with the password on server 2008 std
    and it didn't work.
    I logged in with my account name (not administrator) from SBS2008 and it's
    jng, thank you very very much!!!
    Why doesn't Microsoft tell people about that or tell people that sql08 won't
    install at the first of the installation?
    Oh well.
    Thanks for the help. again jng.
    LVL 2

    Author Comment

    Thanks  amerrigan for your willingness to help - but it appears that the solution i mentioned above that i found on another board (and letting the .NET updates finish) appeared to have been the answer to my problem.
    LVL 2

    Author Comment

    Update: The above fixed the server side problem - but now trying to install the client side of SQL 2008 R2 on Windows 7 64bit w/SP1 I am receiving the same error (multiple machine).
    Unsupported operating system.

    have tried logging in as both user and my Admin account.
    SBS 2008 R2 Physical machine with 2 VM's
    First is SBS 2008R2 running SQL Server 2008 R2 and the second is a VM running SBS 2011 Standard.

    need help.
    I am being pushed to roll this out this week.
    LVL 2

    Author Closing Comment

    found a solution for the server side issue - and a work around for the client side - on another forum board.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Know what services you can and cannot, should and should not combine on your server.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    746 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

    17 Experts available now in Live!

    Get 1:1 Help Now