none
SQL 2008 R2 SP1 Express on Windows server 2008 OS

    Question

  • I'm trying to do silent installation of "SQL Express 2008 R2 SP1 x86" On Windows 2008 Server using below commands to create two SQL instances (TestA and TestB) through windows installer package


    i. SQLEXPR.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /INSTANCENAME=TESTA /NPENABLED=1 /TCPENABLED=1 /SQLSVCACCOUNT=test\administrator /SQLSVCPASSWORD=******** /SQLSVCSTARTUPTYPE=Automatic


    ii. SQLEXPR.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /INSTANCENAME=TESTB /NPENABLED=1 /TCPENABLED=1 /SQLSVCACCOUNT=test\administrator /SQLSVCPASSWORD=******** /SQLSVCSTARTUPTYPE=Automatic


    Above commands works fine on most of the machines. But on some machines SQL installation is getting failed with error "0x84C40013". Please find the attached sql installation logs.

    In failed cases we have observed that one instance is successfully installed and service is visible in Service manager (services.msc)

    Failed cases:
                   Instance (TestA)            Instance (TestB)
    ---------------------------------------------------------------
    Case A :    Installed                        Not Installed
    Case B :   Not installed                      Installed


    Please help me in finding out solution/root cause for this issue.


    System info :
    OS: Windows 2008 along with SP2, dotnet 3.5 SP1 and windows Installer 4.5 installed in it.
    Arch: 32-bit and 64-bit

    SQL ver: SQL Express 2008 R2 SP1 x86 (same package is installed on both on 32 & 64 bit Windows Server)

    Another scenario is i tried re-installing the same instances again for second time, and the surprise is this time it worked and both instances(TEST A and TEST B) were installed.

    can anyone tell me whats this weird behaviour of SQL 2k8 R2 SP1 express that too on windows server 2008 only? Please somebody help me to find out the exact reason for sql failing sometimes and on retry installs successfully.

    =======================================================================
    LOGS:
    TESTA failed SQL setup log:
    ======================================================================
    Setup launched
    Attempting to determine media source
    Media source value not specified on command line argument.
    Setup is launched from media directly so default the value to the current folder.
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Attempt to determine media layout based on file 'c:\8d3b0198291ac4e7c43db17aa971\mediainfo.xml'.
    Media layout is detected as: Core
    Media is a slipstream package
    Only patch related actions can run patch setup.exe, so continuing to run setup.exe from media.
    /? or /HELP or /ACTION=HELP specified: false
    Help display: false
    Checking to see if we need to install .Net version 2.0
    Determining the cluster status of the local machine.
    The local machine is not configured as a cluster node.
    Attempting to find media for .Net version 2.0
    .Net version 2.0 is installed
    RedistMSI::GetExpectedBuildRevision - Setup expects MSI 4.5.6001.22159 at the minimum
    Attempting to get Windows Installer version
    Windows Installer version detected: 4.5.6002.18005
    RedistMSI::IsVistaRTM - Not Vista RTM build
    Required version of Windows Installer is already installed
    Current running setup.exe full path: c:\8d3b0198291ac4e7c43db17aa971\setup.exe
    Media setup.exe file version detected: 2009.100.2500.0
    Locally installed setup.exe full path: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\setup.exe
    Local setup.exe file version detected: 2009.100.2500.0
    Local setup.exe version 2009.100.2500.0 is equal or greater than media version 2009.100.2500.0, so re-launching setup.exe from local
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Install media path: c:\8d3b0198291ac4e7c43db17aa971\x86\setup\
    Media layout: Core
    Attempting to get execution timestamp
    Timestamp: 20120602_050635
    Attempting to launch local setup.exe
    Attempting to launch process C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\setup.exe
    Process returned exit code: 0x84B40000
    Local setup.exe returned exit code: 0x84B40000
    Setup closed with exit code: 0x84C40013
    ======================================================================

    TESTB success sql setup logs:

    ======================================================================
    Setup launched
    Attempting to determine media source
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Attempt to determine media layout based on file 'c:\8d3b0198291ac4e7c43db17aa971\mediainfo.xml'.
    Media layout is detected as: Core
    Media is a slipstream package
    Setup.exe is running locally no check for a slip stream media
    /? or /HELP or /ACTION=HELP specified: false
    Help display: false
    Checking to see if we need to install .Net version 2.0
    Determining the cluster status of the local machine.
    The local machine is not configured as a cluster node.
    Attempting to find media for .Net version 2.0
    .Net version 2.0 is installed
    RedistMSI::GetExpectedBuildRevision - Setup expects MSI 4.5.6001.22159 at the minimum
    Attempting to get Windows Installer version
    Windows Installer version detected: 4.5.6002.18005
    RedistMSI::IsVistaRTM - Not Vista RTM build
    Required version of Windows Installer is already installed
    Strong name verification disabling is not required
    /? or /HELP or /ACTION=HELP specified: false
    Help display: false
    Attempting to launch landing page workflow
    Attempting to set setup mutex
    Setup mutex has been set
    Attempting to launch global rules workflow
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Install media path: c:\8d3b0198291ac4e7c43db17aa971\x86\setup\
    Media layout: Core
    Attempting to get execution timestamp
    Timestamp: 20120602_050635
    Attempting to run workflow RUNRULES /RULES=GlobalRules
    Attempting to launch process C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setup100.exe
    Process returned exit code: 0x00000000
    Workflow RUNRULES /RULES=GlobalRules returned exit code: 0x00000000
    Attempting to launch component update workflow
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Install media path: c:\8d3b0198291ac4e7c43db17aa971\x86\setup\
    Media layout: Core
    Attempting to get execution timestamp
    Timestamp: 20120602_050635
    Attempting to run workflow COMPONENTUPDATE
    Attempting to launch process C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setup100.exe
    Process returned exit code: 0x00000000
    Workflow COMPONENTUPDATE returned exit code: 0x00000000
    Attempting to launch user requested workflow locally
    Attempting to find local setup.exe
    Local bootstrap folder path: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\
    Local setup100.exe full path: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setup100.exe
    Media source: c:\8d3b0198291ac4e7c43db17aa971\
    Install media path: c:\8d3b0198291ac4e7c43db17aa971\x86\setup\
    Media layout: Core
    Attempting to get execution timestamp
    Timestamp: 20120602_050635
    Attempting to run user requested action from local setup100.exe
    Attempting to launch process C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setup100.exe
    Process returned exit code: 0x00000000
    Local setup100.exe returned exit code: 0x00000000
    Attempting to release setup mutex
    Setup mutex has been released
    Setup closed with exit code: 0x00000000
    ======================================================================

    Sooner help is appreciated.

    Thanks,
    Maddy.

    Monday, June 04, 2012 1:20 PM

All replies

  • Hi Manlakshmi,

    Regarding to the error code, which seems the version mismatch problem between the .net framework installed. The .NET Framework requirement for SQL Server 2008 R2 Express Edition is .NET Framework 2.0 SP2, .NET Framework 3.5 SP1, or .NET Framework 4.0 based on which installation package you installed.

    SQL Server Setup will not install the following required components for SQL Server Express ,SQL Server Express with Tools, and SQL Server Express with Advanced Services. You must install these components manually before you run SQL Server Setup:
    • SQL Server Express — .NET Framework 2.0 SP2 and Windows installer 4.5. On Windows Vista SP2, use .NET Framework 3.5 SP1.
    • SQL Server Express with Advanced Services — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.
    • SQL Server Express with Tools — .NET Framework 3.5 SP1, Windows Installer 4.5, and Windows PowerShell 1.0.

    For more inforamtion, please refer to Hardware and Software Requirements for Installing SQL Server 2008 R2

    If it still fails, please provide us the error message logged in the setup log files which are located in %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\


    Regards, Amber zhang


    Tuesday, June 05, 2012 8:24 AM
  • Hi Amber,

      Thanks for your input. Actually the required pre-requistes are already installed on system. But still it was giving the same error. I checked for DotNet 3.5 SP1 from  Add/Remove programs from control panel as well as from Registry "HKLM/SOFTWARE/Microsoft/Net FrameWork Setup/v3.5".

            Actually i have win 2K8 on vSphere client (virtual machine). I reverted back to the same snapshot, and again installed the sql through installer. This time it passed and did't give any error in logs. Now if the issue was with the setup, then second time when i retried installation should have failed right? 

      Sorry i donot  have the logs from the path you mentioned.

      when i tried google  out the error code, it says this error code can come when dotnet not installed properly or when the accout name and password we give to the sql install command is invalid etc. There are lots of reason i find on google for this particular error code (0x84B40000).

       Can you please help me to find out the root cause of this? As this is not consistently reproducible.

    Another thing i want to know is, suppose if i see this issue again, in the  %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ log file, what can i check for which can tell me the cause of this issue?

    Does that Log contain detail information on what went wrong?

    Thanks again for your help Amber.!!

    Tuesday, June 05, 2012 9:07 AM