sql server not supported on sbs 2008 r2 error

Posted on 2012-09-06
Medium Priority
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
  • 4

Expert Comment

ID: 38374189
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.


Accepted Solution

wallsjk earned 0 total points
ID: 38374217
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.

Author Comment

ID: 38384158
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.

Author Comment

ID: 38384778
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.

Author Closing Comment

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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

831 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