SQL Server 2008 R2 setup failing on Windows 2008 R2 SBS


Windows Small Business Server 2011 Premium includes  SQL Server 2008 R2 http://www.microsoft.com/sbs/en/us/editions-overview.aspx. This version is feature by feature the same as SQL 2008 R2 Standard with the difference that it must be installed in an Small Business Server domain or, if purchased separately, an environment with certain characteristics. But, what does that mean?

SQL 2008 R2 Standard for Small Business is supported for installation in a small business domain,
which includes installing on one of the following Windows Server® 2008 R2 editions:

    • Windows® Small Business Server 2011
    • Windows Server® 2008 R2 Standard (must be configured in a
      small business domain configuration). To install this product on Windows Server 2008 R2 Standard edition, the server must be joined to a Small Business Server 2008 R2 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..

If the check fails, you will see the a failed check in the "Operating system supported for edition” topic.

Clicking in the Failed status shows the following message:

Rule Check Result
Rule "Operating system supported for edition" failed.
This SQL Server edition is not supported on this operating system. See SQL Server
Books Online for information about supported operating systems for SQL Small
Business Server edition.

SQL Server 2008 R2 setup logs (check SQL Server detail.txt installation file available on C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log)

2011-07-08 15:52:32 Slp: Rule evaluation message: The SQL Server 2005 Express Tools are not installed.
2011-07-08 15:52:32 Slp: Send result to channel : RulesEngineNotificationChannel
2011-07-08 15:52:32 Slp: Initializing rule : Operating system supported for edition
2011-07-08 15:52:32 Slp: Rule applied features : ALL
2011-07-08 15:52:32 Slp: Rule is will be executed : True
2011-07-08 15:52:32 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.EditionRequirementCheck
2011-07-08 15:52:33 Slp: O destino de uma invocação accionou uma excepção.
2011-07-08 15:52:33 Slp: em System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
em System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
em System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
em System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
em Microsoft.SqlServer.Configuration.SetupExtension.EditionRequirementCheck.CheckSBSEnvironment()
em Microsoft.SqlServer.Configuration.SetupExtension.EditionRequirementCheck.Microsoft.SqlServer.Configuration.RulesEngineExtension.IRuleInitialize.Init(String ruleId)
em Microsoft.SqlServer.Configuration.RulesEngineExtension.RulesEngine.Execute(Boolean stopOnFailure)
2011-07-08 15:52:33 Slp: Rule initialization failed - hence the rule result is assigned as Failed
2011-07-08 15:52:33 Slp: Send result to channel : RulesEngineNotificationChannel
2011-07-08 15:52:33 Slp: Initializing rule : Previous releases of Microsoft Visual Studio 2008
2011-07-08 15:52:33 Slp: Rule applied features : IS;BIDS;Tools;SSMS
2011-07-08 15:52:33 Slp: Rule is will be executed : True

In this case setup was running under local non-domain account. In order to avoid this problem:


  • The SQL setup must be run while logged in to the domain with valid
    domain credentials. The user needs to have domain administrator and local administrator rights.

Comments (7)
  1. Much needed post. says:

    Very useful for SQL Server Setup and Upgrade forum.

    Thank You!

  2. mmcnab says:

    So how do you get the full version of the SQlManagement tools on? Comes up with a must upgrade and then the options are greyed out?  Do you have to create a new instance

  3. Freaky says:

    @mmcnab by installing it on the *additional* server, not on the SBS as the tools conflict with the SQL versions already on it. Setup mentions it incompatible (the management tools) with the installed versions IIRC.

    Then again, it will function fine w/o the tools. You might loose some options, but there's already a management studio installed. The installer is retarded however, you can not remove that version of the management tools w/o removing the whole SQL installation.

  4. anonymous says:

    which edition of sql server 2008 can be installed without a domain environment..tell me please

  5. Jhon says:

    Testing if I am able to made a question.

    Thank you.

  6. John says:


    If I understand correctly, it is possible to buy a Windows® Small Business Server 2011 Standard and install the SQL 2008 R2 Standard for Small Business. If it is possible, it is a lot cheaper than buying the Premium Add-On.

    It is correct ?

    Why Microsoft also sells  the Premium Add-On that forces to have 2 servers.

    Thank you very much.


  7. Luis Alcolete says:

    bom dia, caros amigos, nao consigo baixar o activador de windows 8.1 enterprise, alguem de uma fe superior a dos outros que possa digitar link direto pra tal?, coordiais saudacoes

Comments are closed.

Skip to main content