none
SQL Server 2012 Installation Problem RRS feed

  • Question

  • - I'm trying to install SQLServer 2012 On my testing server with Windows 2K8 nterprise Edition.

    - I got this error message just few seconds after clicking the installation file:

    "TITLE: SQL Server Setup failure.
    ------------------------------

    SQL Server Setup has encountered the following error:

    There was a failure to calculate the applicability of setting ALLINSTANCES.

    Error code 0x85640002.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0x9E9F67A7%25400x724C4CE8

    "

    - The link above doesn't provide any additional information.

    - My Server is: Intell Xeon CPU     E5620 @2.4Hz 2.40 GHz

                           Memory: 8Gb

    Any Help?
    I couldn't find any topic talking about this error..


    عبد اللـــــــــــه

    Sunday, April 1, 2012 6:50 AM

Answers

  • Finally, I got it working

    I extracted the downloaded ISO with winrar and copied it to the server disk and it's now working.

    Thanks for all of you.


    عبد اللـــــــــــه

    • Marked as answer by A_EL Monday, April 2, 2012 10:41 AM
    Monday, April 2, 2012 10:40 AM

All replies

  • are you installing directly from .ISO or did you extract it first to file system?

    in second case did you use Winzip to extract ?

    using Winzip to extract the SQL Server installation does not work correctly and you need to use WinRAR or just mount the .ISO into your machine and install it directly

    Sunday, April 1, 2012 9:28 AM
  • Thanks for the reply.

    I donwloaded the ISO file from MS site and burned it into DVD using PowerIso.

    Tried to install from the DVD and got the error.

    Thought it may be disk error, so i copied the DVD contents to the Hard disk but got same error..


    عبد اللـــــــــــه

    Sunday, April 1, 2012 9:42 AM
  • did you check the installation log file in the directory

    %programfiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\

    see a description here

    http://msdn.microsoft.com/en-us/library/ms143702.aspx

    Sunday, April 1, 2012 9:56 AM
  • SQL Server 2012 requires at least Windows Server 2008 SP2 - have you installed SP2?

    http://msdn.microsoft.com/en-us/library/ms143506.aspx

    Sunday, April 1, 2012 9:58 AM
  • Yes.. I have SP2 and i after i got the error first time, i installed all updates marked in windows-update.

    This is the excpetion details and inner stack from detail_landingPage.txt file:

    Running Action: FinalCalculateSettings
    (01) 2012-04-01 13:22:23 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction" threw an exception during execution.
    (01) 2012-04-01 13:22:23 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: There was a failure to calculate the applicability of setting ALLINSTANCES. ---> Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingApplicabilityException: There was a failure to calculate the applicability of setting ALLINSTANCES. ---> Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingChangeabilityException: There was a failure to calculate the changeability of setting ALLINSTANCES. ---> Microsoft.SqlServer.Chainer.Infrastructure.UnableRetrieveConfigObjectForSettingException: Unable to retrieve a public configuration object type Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings for setting ALLINSTANCES. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: There was an error reflecting type 'Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings'. ---> System.InvalidOperationException: There was an error reflecting type 'Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings'. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
    (01) 2012-04-01 13:22:23 Slp:    at System.Reflection.ParameterInfo.GetParameters(MethodBase method, MemberInfo member, Signature sig, ParameterInfo& returnParameter, Boolean fetchReturnParameter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Reflection.RuntimeConstructorInfo.GetParametersNoCopy()
    (01) 2012-04-01 13:22:23 Slp:    at System.RuntimeType.FilterApplyMethodBaseInfo(MethodBase methodBase, BindingFlags bindingFlags, CallingConventions callConv, Type[] argumentTypes)
    (01) 2012-04-01 13:22:23 Slp:    at System.RuntimeType.GetConstructorCandidates(String name, BindingFlags bindingAttr, CallingConventions callConv, Type[] types, Boolean allowPrefixLookup)
    (01) 2012-04-01 13:22:23 Slp:    at System.RuntimeType.GetConstructorImpl(BindingFlags bindingAttr, Binder binder, CallingConventions callConvention, Type[] types, ParameterModifier[] modifiers)
    (01) 2012-04-01 13:22:23 Slp:    at System.Type.GetConstructor(BindingFlags bindingAttr, Binder binder, Type[] types, ParameterModifier[] modifiers)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.TypeScope.GetConstructorFlags(Type type, Exception& exception)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, MemberInfo memberInfo, Boolean directReference)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.TypeScope.GetTypeDesc(Type type, MemberInfo source, Boolean directReference, Boolean throwOnError)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.StructModel.GetPropertyModel(PropertyInfo propertyInfo)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.StructModel.GetFieldModel(MemberInfo memberInfo)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
    (01) 2012-04-01 13:22:23 Slp:    at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(TypeModel model, String ns, ImportContext context, String dataType, XmlAttributes a, Boolean repeats, Boolean openModel, RecursionLimiter limiter)

    -----------------------------------------------------------------------------

    And this is the error from summary_txt

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2057043966
      Exit facility code:            1380
      Exit error code:               2
      Exit message:                  There was a failure to calculate the applicability of setting ALLINSTANCES.
      Start time:                    2012-04-01 13:22:19
      End time:                      2012-04-01 13:22:42
      Requested action:              LandingPage
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x9E9F67A7%400x724C4CE8&EvtType=0x9E9F67A7%400x724C4CE8

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

    Package properties:
      Description:                   Microsoft SQL Server 2012
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      SPLevel:                       0
      Installation location:         C:\Users\Administrator\Desktop\SQLFULL_ENU\x64\setup\
      Installation edition:         

    User Input Settings:
      ACTION:                        LandingPage
      CONFIGURATIONFILE:            
      ENU:                           true
      HELP:                          false
      INDICATEPROGRESS:              false
      QUIET:                         false
      QUIETSIMPLE:                   false
      UIMODE:                        Normal
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120401_132218\ConfigurationFile.ini

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               The rule result report file is not available.

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingApplicabilityException
        Message:
            There was a failure to calculate the applicability of setting ALLINSTANCES.
        HResult : 0x85640002
            FacilityCode : 1380 (564)
            ErrorCode : 2 (0002)
        Data:
          SettingId = ALLINSTANCES
          WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingApplicabilityException@2
          HelpLink.EvtType = 0x9E9F67A7@0x724C4CE8
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateApplicability()
            at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.CalculateAllSettings(Boolean chainerSettingOnly)
            at Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
        Inner exception type: Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingChangeabilityException
            Message:
                    There was a failure to calculate the changeability of setting ALLINSTANCES.
            HResult : 0x85640003
                    FacilityCode : 1380 (564)
                    ErrorCode : 3 (0003)
            Data:
              SettingId = ALLINSTANCES
              WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingChangeabilityException@3
            Stack:
                    at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateChangeabilityByUser()
                    at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallQueuedSubscriberDelegates()
                    at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.Publish(Publisher publisher)
                    at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateApplicability()
            Inner exception type: Microsoft.SqlServer.Chainer.Infrastructure.UnableRetrieveConfigObjectForSettingException
                Message:
                            Unable to retrieve a public configuration object type Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings for setting ALLINSTANCES.
                HResult : 0x85640007
                            FacilityCode : 1380 (564)
                            ErrorCode : 7 (0007)
                Data:
                  SettingId = ALLINSTANCES
                  ConfigObjectType = Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings
                  WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.UnableRetrieveConfigObjectForSettingException@7
                Stack:
                            at Microsoft.SqlServer.Chainer.Infrastructure.SettingBridge.GetHostingObject()
                            at Microsoft.SqlServer.Chainer.Infrastructure.SettingBridge.ChangeabilityByUser()
                            at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallFunctionWhileAutosubscribing[T](SubscriberDelegate subscriberDelegate, Int32 priority, AutosubscribingFunctionDelegate`1 function)
                            at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateChangeabilityByUser()
                Inner exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
                    Message:
                                    There was an error reflecting type 'Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings'.
                    HResult : 0x84b10001
                                    FacilityCode : 1201 (4b1)
                                    ErrorCode : 1 (0001)
                    Stack:
                                    at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type, String elementXPath)
                                    at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type)
                                    at Microsoft.SqlServer.Chainer.Infrastructure.SettingBridge.GetHostingObject()
                    Inner exception type: System.InvalidOperationException
                        Message:
                                            There was an error reflecting type 'Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings'.
                        Stack:
                                            at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(TypeModel model, String ns, ImportContext context, String dataType, XmlAttributes a, Boolean repeats, Boolean openModel, RecursionLimiter limiter)
                                            at System.Xml.Serialization.XmlReflectionImporter.ImportElement(TypeModel model, XmlRootAttribute root, String defaultNamespace, RecursionLimiter limiter)
                                            at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(Type type, XmlRootAttribute root, String defaultNamespace)
                                            at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace)
                                            at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type, String elementXPath)
                        Inner exception type: System.IndexOutOfRangeException
                            Message:
                                                    Index was outside the bounds of the array.
                            Stack:
                                                    at System.Reflection.ParameterInfo.GetParameters(MethodBase method, MemberInfo member, Signature sig, ParameterInfo& returnParameter, Boolean fetchReturnParameter)
                                                    at System.Reflection.RuntimeConstructorInfo.GetParametersNoCopy()
                                                    at System.RuntimeType.FilterApplyMethodBaseInfo(MethodBase methodBase, BindingFlags bindingFlags, CallingConventions callConv, Type[] argumentTypes)
                                                    at System.RuntimeType.GetConstructorCandidates(String name, BindingFlags bindingAttr, CallingConventions callConv, Type[] types, Boolean allowPrefixLookup)
                                                    at System.RuntimeType.GetConstructorImpl(BindingFlags bindingAttr, Binder binder, CallingConventions callConvention, Type[] types, ParameterModifier[] modifiers)
                                                    at System.Type.GetConstructor(BindingFlags bindingAttr, Binder binder, Type[] types, ParameterModifier[] modifiers)
                                                    at System.Xml.Serialization.TypeScope.GetConstructorFlags(Type type, Exception& exception)
                                                    at System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, MemberInfo memberInfo, Boolean directReference)
                                                    at System.Xml.Serialization.TypeScope.GetTypeDesc(Type type, MemberInfo source, Boolean directReference, Boolean throwOnError)
                                                    at System.Xml.Serialization.StructModel.GetPropertyModel(PropertyInfo propertyInfo)
                                                    at System.Xml.Serialization.StructModel.GetFieldModel(MemberInfo memberInfo)
                                                    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter)
                                                    at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(TypeModel model, String ns, ImportContext context, String dataType, XmlAttributes a, Boolean repeats, Boolean openModel, RecursionLimiter limiter)

    Hope that would help.. i couldn't figure out what is the problem.

    Thanks


    عبد اللـــــــــــه

    Sunday, April 1, 2012 10:30 AM
  • if you search for some of the error messages you find some hint about antivirus blocking the installation etc.

    see

    http://support.microsoft.com/kb/970667

    are install SQL Server 2012 on a cluster ?

    Sunday, April 1, 2012 2:55 PM
  • can you try to run from the commandline: Setup.exe /Action=Install

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Sunday, April 1, 2012 11:26 PM
    Moderator
  • No Antivirus Installed

    I checked the firewall. nothing blocked. however i disabled the firewall and tried...same error.

    No cluster. fresh server with nothing advanced, just for testing SQLServer2012


    عبد اللـــــــــــه

    Monday, April 2, 2012 6:38 AM
  • I tried from commandline.. Same problem.

    Shows the  white window with text "Please wait while Miscrosoft SQL Server 2012 Setup processes the current opertation."

    then the same error message appears.

    Image:


    عبد اللـــــــــــه

    Monday, April 2, 2012 6:45 AM
  • Can you try moving the media from desktop to c:\ ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    • Proposed as answer by jquintas Friday, October 18, 2013 9:11 AM
    Monday, April 2, 2012 7:10 AM
    Moderator
  • I tried from c:\ .. No chance

    I also tried on another server and i got the same error (the other server is nearly same configurations)

    i'm trying re-downloading the image and re-burning it but i don't think it's a media problem.

    Any help is appreciated..


    عبد اللـــــــــــه

    Monday, April 2, 2012 9:37 AM
  • Finally, I got it working

    I extracted the downloaded ISO with winrar and copied it to the server disk and it's now working.

    Thanks for all of you.


    عبد اللـــــــــــه

    • Marked as answer by A_EL Monday, April 2, 2012 10:41 AM
    Monday, April 2, 2012 10:40 AM
  • yes, sql2010 is alreay installe ans sql instance runnig, all i amtrying to do is to run setup again to add feature
    Thursday, July 5, 2012 9:06 PM