none
Problem of installing MS SQL 2012 in Windows 8

    Question

  • im currently wanna install microsoft SQL server 2012 for learning purpose, but some error occurred. it told me that have some kind of error and i really couldn't fix that. tried to GOOGLE, found a thread about this issue that the fellow got the same situation which is very similar to mine but ended up very badly. The link -> http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/a0da3372-ab3d-4af0-b4c4-0d47163e0e03/ Anyone could help is very appreciate :) by the way, im not those kind of computer expert but just a learner, beginner. forgive me if i couldn't get the meaning from you >.<

    Here is the basic information of my computer: 

    Operating System: Windows 8 Pro 64-bit (6.2, Build 9200) (9200.win8_gdr.121023-1503)
    Language: English (Regional Setting: English)
    System Manufacturer: ASUSTeK Computer Inc.
    System Model: N53SV
    BIOS: BIOS Date: 02/10/11 17:21:45 Ver: 04.06.03
    Processor: Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz (4 CPUs), ~2.3GHz
    Memory: 8192MB RAM
    Available OS Memory: 8104MB RAM
    Page File: 3279MB used, 13016MB available
    Windows Dir: C:\Windows
    DirectX Version: DirectX 11

    Here is the error msg:


    SQL Server Setup has encountered the following error:

    There was a failure to calculate the default value of setting INSTANCEID.

    Error code 0x85640001.


    Hopefully anyone can help :)

    Tuesday, November 20, 2012 5:42 PM

All replies

  • Hello,

    Please make sure you enable .NET Framework 3.5 using the following article:

    http://blogs.technet.com/b/aviraj/archive/2012/08/04/windows-8-enable-net-framework-3-5-includes-net-2-0-and-3-0-i-e-netfx3-feature-in-online-amp-offline-mode.aspx

    There are more requirements:

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

    You can try to download the media again and copy it to a local disk. Uncompress the .ISO file using WinRAR and install from there.
    The following article may be helpful:

    http://www.sqlcoffee.com/SQLServer2012_0007.htm   

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, November 20, 2012 6:17 PM
    Moderator
  • If Alberto  suggestions didn't work can you try share / upload SQL Server setup files, please see below "FAQ" on how to locate and upload SQL Server setup logs.

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    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.
    View Ahmed Ibrahim's profile on LinkedIn

    Wednesday, November 21, 2012 1:55 AM
    Moderator
  • I already did what Alberto  told me, but it didnt work. so i paste summary text of log folder here: 

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2057043967
      Exit facility code:            1380
      Exit error code:               1
      Exit message:                  There was a failure to calculate the default value of setting INSTANCEID.
      Start time:                    2012-11-27 18:47:36
      End time:                      2012-11-27 18:53:32
      Requested action:              Install
      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=0x2990711A%400x38AD03A5&EvtType=0x2990711A%400x38AD03A5

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Replication:     SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for FullText:        SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for DQ:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for AS:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for RS:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for RS_SHP:          SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for DQC:             SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for IS:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Conn:            SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Adv_SSMS:        SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SDK:             SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for BC:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for DREPLAY_CTLR:    SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for DREPLAY_CLT:     SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for BIDS:            SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SSMS:            SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SNAC:            SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for SNAC_SDK:        SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Writer:          SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for BOL:             SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for Browser:         SQL Server Setup was canceled before completing the operation. Try the setup process again.
      Next step for MDS:             SQL Server Setup was canceled before completing the operation. Try the setup process again.


    Machine Properties:
      Machine name:                  JETJET-PC
      Machine processor count:       4
      OS version:                    Future Windows Version
      OS service pack:               
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

    Package properties:
      Description:                   Microsoft SQL Server 2012 
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      SPLevel:                       0
      Installation location:         C:\Users\ChunJet\Downloads\SQL Server 2012 Developer Edition (x86 and x64) - DVD (English)\x64\setup\
      Installation edition:          Developer

    Product Update Status:
      None discovered.

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      true
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                <empty>
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   
      CLTRESULTDIR:                  C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir\
      CLTSTARTUPTYPE:                Manual
      CLTSVCACCOUNT:                 NT Service\SQL Server Distributed Replay Client
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir\
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             
      CTLRSTARTUPTYPE:               Manual
      CTLRSVCACCOUNT:                NT Service\SQL Server Distributed Replay Controller
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     
      ENABLERANU:                    false
      ENU:                           true
      ERRORREPORTING:                false
      FEATURES:                      SQLENGINE, REPLICATION, FULLTEXT, DQ, AS, RS, RS_SHP, DQC, BIDS, CONN, IS, BC, SDK, BOL, SSMS, ADV_SSMS, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, MDS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    <empty>
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              SharePointFilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  false
      TCPENABLED:                    0
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  MU
      X86:                           false

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Full-Text and Semantic Extractions for Search
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Data Quality Services
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Analysis Services
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Reporting Services - Native
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Reporting Services - SharePoint
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Data Quality Client
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Integration Services
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Client Tools Connectivity
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Client Tools SDK
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Distributed Replay Controller
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Distributed Replay Client
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Server Data Tools
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Client Connectivity
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Client Connectivity SDK
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Writer
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Documentation Components
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       SQL Browser
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

      Feature:                       Master Data Services
      Status:                        Failed: see logs for details
      Reason for failure:            Setup was canceled for the feature.
      Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20121127_184657\SystemConfigurationCheck_Report.htm

    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.CalculateSettingValueException
        Message: 
            There was a failure to calculate the default value of setting INSTANCEID.
        HResult : 0x85640001
            FacilityCode : 1380 (564)
            ErrorCode : 1 (0001)
        Data: 
          SettingId = INSTANCEID
          WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingValueException@1
          HelpLink.EvtType = 0x2990711A@0x38AD03A5
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.CalculateValue()
            at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallQueuedSubscriberDelegates()
            at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.Publish(Publisher publisher)
            at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.set_Value(T value)
            at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.SetValue(Object newValue, InputSettingSource source)
            at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SetSettingValue[T](String settingName, T value, InputSettingSource source)
            at Microsoft.SqlServer.Configuration.Property`1.SetValueAndSource(Object value, InputSettingSource source)
            at Microsoft.SqlServer.Configuration.InstallWizard.InstanceNameController.set_CustomInstanceName(String value)
            at Microsoft.SqlServer.Configuration.InstallWizard.InstanceNameController.LoadInstanceNameState()
            at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
            at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
            at Microsoft.SqlServer.Configuration.WizardFramework.NavigationButtons.nextButton_Click(Object sender, EventArgs e)
            at System.Windows.Forms.Control.OnClick(EventArgs e)
            at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
            at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
            at System.Windows.Forms.Control.WndProc(Message& m)
            at System.Windows.Forms.ButtonBase.WndProc(Message& m)
            at System.Windows.Forms.Button.WndProc(Message& m)
            at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
            at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
        Inner exception type: System.BadImageFormatException
            Message: 
                    An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
            Stack: 
                    at Microsoft.SqlServer.Chainer.Infrastructure.NativeMethods.ValidateInstanceSyntaxEx(String instanceName, Int32 maxLength)
                    at Microsoft.SqlServer.Configuration.SetupExtension.InstanceStringValidation.ValidateInstanceString(String instanceString, Int32 maxLength)
                    at Microsoft.SqlServer.Configuration.SetupExtension.InstanceStringValidation.ValidateInstanceName(String instanceName)
                    at Microsoft.SqlServer.Configuration.SetupExtension.InstanceIdSetting.GetInstanceIdsByInstanceName(String machineName, String instanceName, ICollection`1 filterForFeatureIds)
                    at Microsoft.SqlServer.Configuration.SetupExtension.InstanceIdSetting.DefaultValue()
                    at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallFunctionWhileAutosubscribing[T](SubscriberDelegate subscriberDelegate, Int32 priority, AutosubscribingFunctionDelegate`1 function)
                    at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.CalculateValue()

    Tuesday, November 27, 2012 11:00 AM
  • Seems like media corruption issue, can you try copying DVD content to local drive and then launch setup.exe from local drive.

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    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.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, November 29, 2012 4:41 AM
    Moderator
  • As Alberto mentioned above, i already tired the suggestion, but still i encountered the same problem.
    Thursday, November 29, 2012 7:25 AM
  • have you downloaded the ISO file? and if yes how did you extract those files?
    Thursday, November 29, 2012 7:30 AM
  • i tired in both way, firstly, i used Daemon tool to mount the image and install from the virtual drive. Secondly, i try to extract with WinRaR to local drive and install from there, but the results were all the same. 
    Thursday, November 29, 2012 7:38 AM
  • Try extracting using Magic ISO tool and I think that should work
    Thursday, November 29, 2012 11:45 AM
  • used Magic ISO to extract the content, run the installer from local drive, but same error occurred. 
    Thursday, November 29, 2012 9:45 PM
  • Can you try installing commandline ?

    http://blogs.msdn.com/b/ai/archive/2012/05/01/installing-sql-aerver-2012-in-unattended-mode-using-command-line.aspx


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    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.
    View Ahmed Ibrahim's profile on LinkedIn


    Friday, November 30, 2012 6:09 AM
    Moderator
  • from the above link, i just understood the second step which is to create a ConfigurationFile.ini with all those words highlighted in yellow colour. for the first step, really quite blur with it. sorry for causing any inconvenience.
    Monday, December 03, 2012 3:24 AM