none
Kindly help me on SQL Server Installation of 2008 R2 in Windows 7 machine

    Question

  • I tried Installing SQL Server 2008 R2.

    I get the following error "The system cannot find the specified path".

    then I click Ok then after sometime I get the error MSSQLSERVERADHelper100 and the Installation is failed.

    These errors I am getting on Windows 7 machine

    Kindly help me on this.

    Saturday, March 30, 2013 10:56 AM

Answers

All replies

  • Hello,

    Please share with us the Summary.txt log file. The following article may help you locate the file.

    http://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspx

    I would try to download the media again, extract the content on the local drive, and run SQL Server setup again.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Saturday, March 30, 2013 8:13 PM
  • I have here by attached the Summary Text log.

     

    Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068024488
      Exit facility code:            1212
      Exit error code:               29528
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2013-03-31 03:07:11
      End time:                      2013-03-31 03:19:05
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_030406\sql_engine_core_inst_Cpu64_1.log
      Exception help link:         Machine Properties:
      Machine name:                  BMH326161
      Machine processor count:       4
      OS version:                    Windows 7
      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

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

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      Installation location:         c:\0e42c88a89d95529099372c07a5977\x64\setup\
      Installation edition:          EXPRESS_ADVANCED

      Slipstream:                    True
      SP Level                       2

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      True
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:            
      CUSOURCE:                     
      ENABLERANU:                    True
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE,REPLICATION,SSMS,SNAC_SDK
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      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:                    SQLExpress
      INSTANCENAME:                  SQLEXPRESS
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                     c:\0e42c88a89d95529099372c07a5977\PCUSOURCE
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           APAC\JIJ3KOR
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      X86:                           False

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0x1639
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_030406\sql_engine_core_inst_Cpu64_1.log
      MSI error description:        
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

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

    Saturday, March 30, 2013 10:21 PM
  • Hello,

    Please share with us the following log also.

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_030406\sql_engine_core_inst_Cpu64_1.log

    You can also examine that log yourself. See if you can find “MSINEWINSTANCE requires a new instance that is not installed” on that log. If you find it, please read the following thread:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/1a3a3992-a28d-4b47-8545-1c8aca5e83bd  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by JayanthJS Sunday, March 31, 2013 12:05 PM
    Saturday, March 30, 2013 11:19 PM
  • I have here attached the Log from

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_030406\sql_engine_core_inst_Cpu64_1.log

    === Verbose logging started: 3/31/2013  3:18:58  Build type: SHIP UNICODE 5.00.7601.00  Calling process: c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x64\setup100.exe ===
    MSI (c) (08:40) [03:18:58:886]: Resetting cached policy values
    MSI (c) (08:40) [03:18:58:886]: Machine policy value 'Debug' is 0
    MSI (c) (08:40) [03:18:58:886]: ******* RunEngine:
               ******* Product: c:\0e42c88a89d95529099372c07a5977\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (08:40) [03:18:58:886]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (08:40) [03:18:58:886]: Grabbed execution mutex.
    MSI (c) (08:40) [03:18:58:886]: Cloaking enabled.
    MSI (c) (08:40) [03:18:58:886]: Attempting to enable all disabled privileges before calling Install on Server
    MSI (c) (08:40) [03:18:58:886]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (18:90) [03:18:58:886]: Running installation inside multi-package transaction c:\0e42c88a89d95529099372c07a5977\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
    MSI (s) (18:90) [03:18:58:886]: Grabbed execution mutex.
    MSI (s) (18:2C) [03:18:58:886]: Resetting cached policy values
    MSI (s) (18:2C) [03:18:58:886]: Machine policy value 'Debug' is 0
    MSI (s) (18:2C) [03:18:58:886]: ******* RunEngine:
               ******* Product: c:\0e42c88a89d95529099372c07a5977\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (18:2C) [03:18:58:886]: Machine policy value 'TransformsSecure' is 0
    MSI (s) (18:2C) [03:18:58:886]: User policy value 'TransformsAtSource' is 0
    MSI (s) (18:2C) [03:18:58:886]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (18:2C) [03:18:58:886]: Specified instance {2806FF71-18DB-4073-8985-4AAB7F7D9D18} via transform :InstID06.mst;:InstName06.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
    MSI (s) (18:2C) [03:18:58:886]: MainEngineThread is returning 1639
    MSI (s) (18:90) [03:18:58:886]: User policy value 'DisableRollback' is 0
    MSI (s) (18:90) [03:18:58:886]: Machine policy value 'DisableRollback' is 0
    MSI (s) (18:90) [03:18:58:886]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (18:90) [03:18:58:886]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (18:90) [03:18:58:886]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (18:90) [03:18:58:886]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
    MSI (s) (18:90) [03:18:58:886]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
    MSI (s) (18:90) [03:18:58:886]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (s) (18:90) [03:18:58:886]: Restoring environment variables
    MSI (c) (08:40) [03:18:58:886]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (08:40) [03:18:58:886]: MainEngineThread is returning 1639
    === Verbose logging stopped: 3/31/2013  3:18:58 ===

     

    Sunday, March 31, 2013 6:05 AM
  • I followed the procedure fromthe link which you specified.

    But still I end with the old problem and also along with it I get "The MOF compiler could not connect with the WMI server".

    Kindly help me.

    Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068024488
      Exit facility code:            1212
      Exit error code:               29528
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2013-03-31 13:18:40
      End time:                      2013-03-31 13:32:43
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_131601\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.4000.0%26EvtType%3d0xA60E3551%400xD3BEBD98%401211%401

    Machine Properties:
      Machine name:                  BMH326161
      Machine processor count:       4
      OS version:                    Windows 7
      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

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

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      Installation location:         c:\88a80b525e110e536d\x64\setup\
      Installation edition:          EXPRESS_ADVANCED

      Slipstream:                    True
      SP Level                       2

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      True
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:            
      CUSOURCE:                     
      ENABLERANU:                    True
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE,REPLICATION,SSMS,SNAC_SDK
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      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:                    BMH326161
      INSTANCENAME:                  BMH326161
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                     c:\88a80b525e110e536d\PCUSOURCE
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           APAC\JIJ3KOR
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      X86:                           False

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:        Configuration error description: The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130331_131601\Detail.txt

    Rules with failures:

    Global rules:

    Scenario specific rules:

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

    Sunday, March 31, 2013 8:19 AM
  • Thanks Alberto Morillo,

    I followed the steps in the link provided by you, and I installed the SQL SERVER 2008 R2 SP1 successfully.

    Thanks a lot.

    Sunday, March 31, 2013 12:04 PM
  • Hello,

    Thank you for letting us know.

    Thank you for visiting MSDN forums!

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, March 31, 2013 3:21 PM