MAP - SQL Server Express Installation failure RRS feed

  • Question

  • I am trying to install MAP 5.0.3431.0 on a Dell PowerEdge 830 server running 2003 Enterprise SP2. This is primarily used as our WSUS server. The SQL installation fails with following message: Unknown error (0x24842db).

    I realise that WSUS already uses another version of SQL, is this the likely cause of the issue?  Add or Remove Programs contains the following SQL entries:

    SQL Server 2008 R2, SQL Server 2008 R2 Native Client, SQL Server 2008 R2 Setup (English), SQL Server 2008 R2 Setup Support Files, SQL Server Browser, SQL Server VSS Writer

    I have tried to manually start the SQL Server (MAPS) service but this fails.

    I do not want to uninstall SQL in case it affects WSUS, is there a way round it please?

    Details of SQL Server Express installer log file are shown below.



     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):           -1035451685
      Exit facility code:            584
      Exit error code:               17115
      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:                    2010-11-17 13:27:05
      End time:                      2010-11-17 13:41:39
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101117_132124\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.1600.1%26EvtType%3d0xB4A84AA1%400xC24842DB



    Machine Properties:
      Machine name:                  ARTHUR
      Machine processor count:       2
      OS version:                    Windows Server 2003
      OS service pack:               Service Pack 2
      OS region:                     United Kingdom
      OS language:                   English (United States)
      OS architecture:               x86
      Process architecture:          32 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
      SPLevel:                       0
      Installation location:         d:\acbd534fa828b8f95087a6b368\x86\setup\
      Installation edition:          EXPRESS

    User Input Settings:
      ACTION:                        Install
      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:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101117_132124\ConfigurationFile.ini
      ENABLERANU:                    True
      ENU:                           True
      ERRORREPORTING:                True
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              c:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MAPS
      INSTANCENAME:                  MAPS
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PID:                           *****
      QUIET:                         True
      QUIETSIMPLE:                   False
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           BUILTIN\Administrators
      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\20101117_132124\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xC24842DB
      Configuration error description: The service did not respond to the start or control request in a timely fashion. 
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101117_132124\Detail.txt

    Rules with failures:

    Global rules:

    Scenario specific rules:

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




    • Edited by OLCS Tuesday, December 7, 2010 4:32 PM
    Wednesday, November 17, 2010 2:19 PM


  • Probably need to look at the contents of the SQL installer log file at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101117_132124\Detail.txt to diagnose this further.

    It may be easier to pre-install a SQL instance using the standalone SQL Express installer before installing MAPS.   The SQL installer UI may give you a better error message as to why the SQL install is failing.

    You can obtain the SQL installer here: http://www.microsoft.com/express/Database/InstallOptions.aspx  (choose the "Database Only" download).

    If you manually install SQL Express, make sure to set the default database collation order, this will be important to you as I assume you're in the UK.  You'll need to name the installed SQL instance "MAPS".  Instructions for doing this are here: http://social.technet.microsoft.com/wiki/contents/articles/manually-installing-sql-server-for-use-with-map-toolkit.aspx

    Once you've pre-installed a SQL instance named 'MAPS', just re-run the MAP Toolkit installer and it will find and use the preexisitng database engine instance automatically.

    • Edited by Jay Sauls [MSFT]Microsoft employee Wednesday, December 1, 2010 3:57 PM added detail about running MAP installer after preinstalling SQL instance.
    • Marked as answer by OLCS Tuesday, December 7, 2010 4:32 PM
    Wednesday, December 1, 2010 3:55 PM