cannot install Sql server 2008 R2 on Windows Server 2008 R2 - Please help! - get Slp: EditionRequirementCheck Rule Check : The edition is not allowed on this OS.

Question

Hi

I've done lots of searching, but unable to find a solution to this issue. I followed http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx which indicates the Sql server 2008 R2 should work with Server 2008 x64 Standard R2 & I've done the .NET Framework 3.5 using Control Panel -> Programs and Features -> Turn On/Off features. When I go through the installation, just after entering the product key, I choose only database server, and get a fail on the next screen "This OS not supported" ???

Can anyone offer any advice, the error message regarding SBS doesn't make sense since this is Windows 2008 R2 Standard, non SBS.

I've included log files below which hopefully can help...

thanks for ANY advice, really really stuck now.

Thanks

Jonathan

2013-01-07 20:49:50 Slp: EditionRequirementCheck Rule Check : The edition is not allowed on this OS.
2013-01-07 20:49:50 Slp: Evaluating rule        : EditionRequirementCheck
2013-01-07 20:49:50 Slp: Rule running on machine: NTSERVER2
2013-01-07 20:49:50 Slp: Rule evaluation done   : Failed
2013-01-07 20:49:50 Slp: Rule evaluation message: 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.

Overall Summary:

  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2013-01-07 20:47:00
  End time:                      2013-01-07 20:48:34
  Requested action:              ComponentUpdate

Machine Properties:
  Machine name:                  NTSERVER2
  Machine processor count:       4
  OS version:                    Windows Server 2008 R2
  OS service pack:               Service Pack 1
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         E:\x64\setup\
  Installation edition:          EVAL

User Input Settings:
  ACTION:                        ComponentUpdate
  CONFIGURATIONFILE:            
  ENU:                           True
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  PASSPHRASE:                    *****
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\SystemConfigurationCheck_Report.htm

.... had to cut this down

2013-01-07 20:49:48 Slp: =====================================
2013-01-07 20:49:48 Slp: MSI feature install scenario: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 --> Install
2013-01-07 20:49:48 Slp: MSI feature config  scenario: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 --> Install
2013-01-07 20:49:48 Slp: Keeping /FEATURES value: SQLENGINE
2013-01-07 20:49:48 Slp: =====================================
2013-01-07 20:49:48 Slp: Attempting to save the input setting 'FEATURES' into datastore
2013-01-07 20:49:48 Slp: Setting source: UI
2013-01-07 20:49:48 Slp: Getting hosting object 'Microsoft.SqlServer.Configuration.SetupExtension.SlpChainerInputSettings' from datastore and updating property 'Features'.
2013-01-07 20:49:48 Slp: Serializing the hosting object back datastore.
2013-01-07 20:49:48 Slp: Update input setting store with the new source information
2013-01-07 20:49:49 Slp: Completed Action: AdjustFeaturesAfterCalculation, returned True
2013-01-07 20:49:49 Slp: Rules to be checked: Sql2005SsmsExpressFacet;EditionRequirementCheck;VSShellInstalledRule;ASSPISharePointPlatformSupportedCheck;ASSPIOperationSystemCheck;ASSPIUserIsFarmAdminCheck;ASSPIIISVersionCheck;ASSPI64bitsMachineCheck;ASSPINoExistingIMBICheck;ASSPINo32BitsOrWowCheck;ASSPIExistingFarmRequiresUpgradeCheck;ASSPIExistingFarmRequiresMoss14FarmCheck;ASSPINewO14EnterpriseFarmUnconfiguredCheck;ASSPINewFarmNeedsUpgradeToO14MossEnterpriseCheck;ASSPINewFarmRequiresMoss14BitsCheck;ASSPINewFarmRequiresMossBitsCheck;SharedComponentsUpgradeRule;ASSPIInstanceNameNotInUseCheck;ASSPIProvisionResultValidCheck;SlipstreamMediaInfoCheck;RS_W2K3IA64InstallCheck;ASSPIExistingFarmMustBeAvailableCheck;ASSPINewFarmRequiresNewAdminSiteCheck;ASSPIRequiresCompleteFarmCheck
2013-01-07 20:49:49 Slp: If any rule does not pass, setup can still continue: True
2013-01-07 20:49:49 Slp: Adding rule result notification channel: RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: Sql2005SsmsExpressFacet
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.Sql2005SsmsExpressFacet
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: EditionRequirementCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.EditionRequirementCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: VSShellInstalledRule
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.VSShellInstalledFacet
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPISharePointPlatformSupportedCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPISharePointPlatformSupportedCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIOperationSystemCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIOperationSystemCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIUserIsFarmAdminCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIUserIsFarmAdminCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIIISVersionCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIIISVersionCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPI64bitsMachineCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPI64bitsMachineCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINoExistingIMBICheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINoExistingIMBICheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINo32BitsOrWowCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINo32BitsOrWowCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIExistingFarmRequiresUpgradeCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIExistingFarmRequiresUpgradeCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIExistingFarmRequiresMoss14FarmCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIExistingFarmRequiresMoss14FarmCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINewO14EnterpriseFarmUnconfiguredCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINewO14EnterpriseFarmUnconfiguredCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINewFarmNeedsUpgradeToO14MossEnterpriseCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINewFarmNeedsUpgradeToO14MossEnterpriseCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINewFarmRequiresMoss14BitsCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINewFarmRequiresMoss14BitsCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINewFarmRequiresMossBitsCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINewFarmRequiresMossBitsCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: SharedComponentsUpgradeRule
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SharedComponentsUpgradeRule
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIInstanceNameNotInUseCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstanceNameNotInUseCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIProvisionResultValidCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIProvisionResultValidCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: SlipstreamMediaInfoCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SlipstreamMediaInfoCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: RS_W2K3IA64InstallCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.RSExtension.RSW2K3IA64InstallBlocker
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIExistingFarmMustBeAvailableCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIExistingFarmMustBeAvailableCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPINewFarmRequiresNewAdminSiteCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPINewFarmRequiresNewAdminSiteCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Loading rule: ASSPIRequiresCompleteFarmCheck
2013-01-07 20:49:49 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIRequiresCompleteFarmCheck
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Executing rules engine...
2013-01-07 20:49:49 Slp: Start rule execution, total number of rules loaded: 24
2013-01-07 20:49:49 Slp: Initializing rule      : SQL Server 2005 Express tools
2013-01-07 20:49:49 Slp: Rule applied features  : SSMS;Adv_SSMS
2013-01-07 20:49:49 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:49 Slp: Rule is will be executed  : False
2013-01-07 20:49:49 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:49 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:49 Slp: Initializing rule      : Operating system supported for edition
2013-01-07 20:49:49 Slp: Rule applied features  : ALL
2013-01-07 20:49:49 Slp: Rule is will be executed  : True
2013-01-07 20:49:49 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.EditionRequirementCheck
2013-01-07 20:49:50 Slp: EditionRequirementCheck Rule Check : The edition is not allowed on this OS.
2013-01-07 20:49:50 Slp: Evaluating rule        : EditionRequirementCheck
2013-01-07 20:49:50 Slp: Rule running on machine: NTSERVER2
2013-01-07 20:49:50 Slp: Rule evaluation done   : Failed
2013-01-07 20:49:50 Slp: Rule evaluation message: 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.
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Previous releases of Microsoft Visual Studio 2008
2013-01-07 20:49:50 Slp: Rule applied features  : IS;BIDS;Tools;SSMS
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint .NET Framework Supported Check
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Operating system requirement for SQL Server PowerPivot for SharePoint
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : User account requirement for Farm administrator
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Internet Information Services version
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : 64-bit processor
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Single instance requirement
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : 64-bit operating system
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint configuration and upgrade check for existing farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : PowerPivot for SharePoint check for existing farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint configuration check for new farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint configuration and upgrade check for new farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint installation requirement for new farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint configuration requirement for new farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SQL Server 2008 and SQL Server 2008 R2 Shared Component Upgrade Rule
2013-01-07 20:49:50 Slp: Rule applied features  : IS;BIDS;Tools;SSMS
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : PowerPivot service instance name
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Same version requirement for multi-server farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Update Setup Media Language Compatibility
2013-01-07 20:49:50 Slp: Rule applied features  : ALL
2013-01-07 20:49:50 Slp: Rule is will be executed  : True
2013-01-07 20:49:50 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SlipstreamMediaInfoCheck
2013-01-07 20:49:50 Slp: Evaluating rule        : SlipstreamMediaInfoCheck
2013-01-07 20:49:50 Slp: Rule running on machine: NTSERVER2
2013-01-07 20:49:50 Slp: Rule evaluation done   : Succeeded
2013-01-07 20:49:50 Slp: Rule evaluation message: The language of the original SQL Server 2008 R2 media and the service pack match.
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Windows 2003 IA64 Check
2013-01-07 20:49:50 Slp: Rule applied features  : RS
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : SharePoint availability check for existing farm
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Site name requirement for new SharePoint server
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Initializing rule      : Complete Farm requirement for PowerPivot for SharePoint
2013-01-07 20:49:50 Slp: Rule applied features  : AS_SPI
2013-01-07 20:49:50 Slp: Rule is not applicable to the specified features.
2013-01-07 20:49:50 Slp: Rule is will be executed  : False
2013-01-07 20:49:50 Slp: Rule evaluation done   : Skipped
2013-01-07 20:49:50 Slp: Send result to channel : RulesEngineNotificationChannel
2013-01-07 20:49:50 Slp: Saving results to datastore...
2013-01-07 20:49:50 Slp: Saved to directory.......C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\SystemConfigurationCheck_Report.htm
2013-01-07 20:49:50 Slp: Sco: Attempting to create directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\resources
2013-01-07 20:49:50 Slp: Sco: Attempting to create directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\resources, security descriptor
2013-01-07 20:49:50 Slp: Sco: Attempting to set directory full path
2013-01-07 20:49:50 Slp: Sco: Attempting to normalize directory path C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\resources
2013-01-07 20:49:50 Slp: Sco: Attempting to set security descriptor for directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\resources, security descriptor
2013-01-07 20:49:50 Slp: Sco: Attempting to check if directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\resources exists
2013-01-07 20:49:50 Slp: Sco: SDDL is NULL/empty and overwriteSecurityDescriptor is false, so nothing to do, return.
2013-01-07 20:49:50 Slp: Generating HTML report by applying XsltTransformation and saving to Log folder...
2013-01-07 20:49:50 Slp: Rules evaluation report is available now at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130107_204647\SystemConfigurationCheck_Report.htm

Answer 1

Hello,

SQL Server Standard for Small Business should be installed. Please see the following article about the requirements to install SQL Server 2008 R2 Standard Edition for Small Business:

http://blogs.msdn.com/b/joaol/archive/2011/07/11/sql-server-2008-r2-setup-failing-on-windows-2008-r2-sbs.aspx   

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Alberto

This is a bit of a shock, as I've just spent $700 on something I can't return, because its now open? Is there anyway it would load on the Server 2008 R2 OS that is running now, for example if I remove domain function from this machine, or add another role, would it install?

If there is that option I will just do that.

I don't understand why this product isn't supported on Windows Server 2008 standard edition R2, and why the "SBS" version is needed?

What verion of windows would this SQL 2008 Standard Edition R2 run on?

Can you shed some light on it?

Thanks

Jonathan

Answer 3

Steps to diagnose "Operating system supported for edition" for Small Business

From Requirements for Installing SQL 2008 Standard Edition for Small Business,

"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."

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

Answer 4

Hi Anuragsh

I've tried running the installer as Administrator, and a domain user who has domain domain administrators, and administrators. That should be sufficient?

Thanks for the help

Jonathan

Answer 5

Hello,

I know you can install Express Edition, but all licensed editions of SQL Server will fail to install with the same failed rule.

My recommendation is to call Microsoft Licensing and see if they can allow you to return the open box and be able to obtain in return SQL Server Standard for SBS. You can call Microsoft Licensing at 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time).

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 6

Thanks Alberto for the number.

If you know, can you answer this:

 The install is failing because of :

a. I have Windows Server 2003 Standard R2 - SBS

b. I have Windows Server 2003 Standard R2

c. Because I have it as a domain controller

?

thanks

Jonathan

Answer 7

Hello,

Small Business Server is especial because it allows you to have a domain controller, an Exchange Server, SQL Server, SharePoint , etc. on the same box. All editions of SQL Server have issues with domain controllers, they are not recommended on domain controllers, but SQL Server Standard for Small Business is created to work on that special environment.

SQL Server setup is just avoiding you to install an edition of SQL Server that will lead you to problems on a SBS domain/environment.

Hope this helps. I hope this is the answer you are looking for.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 8

Hey Alberto

That is - thanks. So I presume if I remove the domain role (unjoin domain) from this machine, and have it as a 'standalone' WORKGROUP machine it will load ok ? If so that would be so execellent!

Thanks,

Jonathan

Answer 9

Hello,

All editions of SQL Server will work great if you install them on a Windows Server (non-SBS) that is part of a workgroup.

Yes, remove the server from the SBS domain, and try to install SQL Server again.

However, you may have to use SQL Server authentication to connect from applications on the SBS domain.

Hope this helps..

Regards,
Alberto Morillo
SQLCoffee.com

Answer 10

Hi Alberto

No luck with MSFT licensing, Still need the domain. I found something very interesting (option "C" below) - So I either need a. Windows 2008 R2 SBS, or B. SQL 2008 R2 "non SBS" edition, Or C. One of these conditions must be met:

If the operating system is Windows Server 2008 Standard, then:
1. Windows Server 2008 Standard must be joined to a domain

2. The domain and other domain does not exist a trust relationship

3. The domain cannot have any sub-domain

4. The domain users and equipment the sum of not more than 75

5.  Customers can not be in the same serial number of the SQL Server software running in the domain of other operating systems

If these conditions are not met, then we will run into the operating system does not support error as you got. You maybe use Windows Server 2008 Standart instead of as Sean mentioned.

We do have more than 75 users/equipment, which I have reduced to less than 75.

Do you know if this is still valid and maybe just taking time for it to 'refresh' ?

info from: http://www.microsoft.com/sqlserver/2008/tr/tr/small-business.aspx

states clearly Windows 2008 Standard....

offical MS doc - http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=3&cad=rja&ved=0CEUQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F4%2FB%2F1%2F4B188CBB-8B48-4AA8-815F-D2BAA779F3DA%2F1033%2FSQL%2520Server%25202008%2520R2%2520Standard%2520for%2520SB_OEM.docx&ei=W6HsUOOjD4WQqwGfzYCgCQ&usg=AFQjCNFN0A9HGz5K39uPJWivOM_DWLUizQ&bvm=bv.1357316858,d.aWM

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/beb6ec94-7421-4517-8533-738ca4805c60/

http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx

thanks for any advise going forward on this tricky subject! As you have pointed out my issue is I have Windows 2008 Standard x64 R2 non SBS, and SQL 2008 Standard R2 "SBS" - so one is SBS and the other is NOT.

It seems under very VERY special circumstance the SBS SQL 2008 R2 will work with NON SBS Server 2008 R2 if the specific domain criteria above is met, but I am still not meeting it sadly. Will double check things and report back.

Please let me know if there are any suggestions in the mean time as I'm stuck with this 'open box' of sql now... argh!.

Thanks,

Jonathan

Answer 11

Hello Jonathan,

To be able to install SQL Server 2008 R2 Standard for SBS on Windows Server 2008 R2 Standard (non-SBS), the Windows server needs to be part of a SBS domain, and there is no SBS domain on your network.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 12

Hi Alberto / everyone

Thank you very much for the help. Alberto, it might be something new for you as well - I wanted to post the final solution to get this working. In the end I had to perform the following to get SQL 2008 R2 SBS to install on my Win2008 Server R2 non SBS.

- remove secondary domain controller

- ensure all master fismo roles are on the single domain controller

- remove (clean up ) additional users & computers with in the domain which have been replaced over the years so the total number was under 75 (at about 60 right now).

- my domain is still at windows 2003 level (not 2008 or 2008 R2).

Upon this criteria, and re-running the setup for SQL 2008 R2, I was able to pass the OS check and proceed with the installation, which completed successfully!

I can post the logs if it would be helpful towards helping users in the future with similar issues.

Let me know if it is useful Alberto - and thanks again for the help.

Jonathan

Answer 13

Hello,

No. I am marking your post as answer. I have not tried that myself.

Thank you for sharing your experience with us.

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com