Share via

SQL Server 2008 R2 setup failing on Windows 2008 R2 SBS

  • Article

 

Windows Small Business Server 2011 Premium includes  SQL Server 2008 R2 https://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

  • Anonymous
    September 29, 2011
    Very useful for SQL Server Setup and Upgrade forum. Thank You!

  • Anonymous
    October 05, 2011
    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

  • Anonymous
    March 28, 2012
    The comment has been removed

  • Anonymous
    July 07, 2012
    which edition of sql server 2008 can be installed without a domain environment..tell me please

  • Anonymous
    November 27, 2013
    Testing if I am able to made a question. Thank you.

  • Anonymous
    November 27, 2013
    Hello. 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. Regards.

  • Anonymous
    March 04, 2015
    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