none
Cannot install Microsoft SQL Server 2005 Express Edition x86

    Question

  • I recently (yesterday) installed a fresh copy of Windows XP with Service Pack 2 applied.

    I proceeded with Visual Studio 2005 Express Editions installation straight away.

    But I cannot install Microsoft SQL Server 2005 Express Edition x86.

    I choose to install Microsoft SQL Server 2005 Express Edition x86 component along with every component of visual studio but it simply would not install.

    In the end, after the installation of each complete is complete, I simply get an error message saying that Microsoft SQL Server 2005 Express Edition x86 failed to install.

    What is the problem?

    Friday, March 10, 2006 3:47 PM

Answers

  • First take a look at the following file: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt. This should point you to which component failed and the specific log file for the component. When you open the component log file search for "Value 3" (this is a Windows Installer code for the error section). Take a look at +/- 10 lines for the error.

    If the summary.txt file doesn't provide any clues, take a look at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*_core(local).txt - open the most recent one if there are multiple. Go to the end of the file and you should find some clues as to why the installation failed.

    Friday, March 10, 2006 3:56 PM

All replies

  • First take a look at the following file: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt. This should point you to which component failed and the specific log file for the component. When you open the component log file search for "Value 3" (this is a Windows Installer code for the error section). Take a look at +/- 10 lines for the error.

    If the summary.txt file doesn't provide any clues, take a look at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*_core(local).txt - open the most recent one if there are multiple. Go to the end of the file and you should find some clues as to why the installation failed.

    Friday, March 10, 2006 3:56 PM
  • I looked. There were three errors and all of them said that installation cannot be done to a compressed drive

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

    Error           : SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.

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

    I'll remove drive compression and try again.

    Thanks for help!

    Friday, March 10, 2006 4:10 PM
  • I am having the same problem - cannot install SQL Server Express, I looked in the file you mentioned to the other fellow and it says:

    D43QNW81 : SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

    but I HAVE removed all components except a thing called Enterprise Library June 2005, and thaat one will not un-install without dot net framework 1.1

     

    is that it? do I have to go ALL the way back?

     

    any help will be much appreciated, I installed the whole works in a Virutal machine and now I am trying to install it on my base machine (because the Virtual one is too slow)


     

     

    Friday, March 10, 2006 7:37 PM
  • David,

    You can take a look at the latest *_core(local).log file to see which old component it's detecting. The log files can be found here: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files

    If you email me directly at dtjones@microsoft.com I can send you a clean up script. The script isn't supported but we've had good luck with it.

    Cheers,
    Dan

    Friday, March 10, 2006 8:55 PM
  • Hi Dan,

    I have the same problem. Would you please help me to solve the issue?

    Thanks,

    Ali

     

    Friday, January 18, 2008 7:33 PM
  • I had the same issue with someone at my job. I found that the individual had the c :\drive compressed. If you go to My Computer and go to the properties of your c:\ drive. Make sure that there is no check mark in the box that states, "Compress drive to save disk space". If it is checked take the check out and click ok to the window that pops up. Once it take the compression off the drive try your installation again. I hope this helps.

     

    Monday, June 16, 2008 3:39 PM
  • Hello,

     

    I have a work laptop which once was able to install MS SQL 2005, IE 7, MSXML 6, SQL 2005 Express.  After the techs erased the hard drive and reinstalled a new image (contains all the software, applications, updates, O/S, etc. for work and drivers for a wireless sprint card because originally the wireless card would not function) I have not been able to install SQL 2005 nor any of the other apps mentioned in the first line.  The techs who have unrestricted, administrative access also have been unsuccessfull at installing these.  I stand firm that it has to do with security policies; even after having full access (as administrator of local machine).  If I am wrong please explain.  And thank you for any help you can provide.  Below are the error reports I get.

     

    First Report:

    === Verbose logging started: 7/14/2008  10:26:47  Build type: SHIP UNICODE 3.01.4000.4039  Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
    MSI (c) (A0:18) [10:26:47:349]: Resetting cached policy values
    MSI (c) (A0:18) [10:26:47:349]: Machine policy value 'Debug' is 0
    MSI (c) (A0:18) [10:26:47:349]: ******* RunEngine:
               ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (A0:18) [10:26:47:349]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (A0:18) [10:26:47:349]: Grabbed execution mutex.
    MSI (c) (A0:18) [10:26:47:365]: Cloaking enabled.
    MSI (c) (A0:18) [10:26:47:365]: Attempting to enable all disabled priveleges before calling Install on Server
    MSI (c) (A0:18) [10:26:47:365]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (C4:74) [10:26:47:396]: Grabbed execution mutex.
    MSI (s) (C4:68) [10:26:47:396]: Resetting cached policy values
    MSI (s) (C4:68) [10:26:47:396]: Machine policy value 'Debug' is 0
    MSI (s) (C4:68) [10:26:47:396]: ******* RunEngine:
               ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (C4:68) [10:26:47:396]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (C4:68) [10:26:47:396]: MainEngineThread is returning 1605
    MSI (c) (A0:18) [10:26:47:396]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (A0:18) [10:26:47:396]: MainEngineThread is returning 1605
    === Verbose logging stopped: 7/14/2008  10:26:47 ===

     

     

    Second report:

    Microsoft SQL Server 2005 9.00.1399.06
    ==============================
    OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
    Time            : Mon Jul 14 10:24:19 2008
     
    Machine         : PM08737
    Product         : Microsoft SQL Server Setup Support Files (English)
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLSupport_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server Native Client
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLNCLI_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft Office 2003 Web Components
    Product Version : 11.0.6558.0
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_OWC11_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server 2005 Books Online (English)
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_BOL_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server 2005 Backward compatibility
    Product Version : 8.05.1054
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_BackwardsCompat_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : SQLXML4
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLXML4_1.log
    --------------------------------------------------------------------------------

    Monday, July 14, 2008 3:10 PM
  • Sorry, I previously posted this message to the wrong person (i think) .  It was intended for you, Dan.

     

    Hello,

     

    I have a work laptop which once was able to install MS SQL 2005, IE 7, MSXML 6, SQL 2005 Express.  After the techs erased the hard drive and reinstalled a new image (contains all the software, applications, updates, O/S, etc. for work and drivers for a wireless sprint card because originally the wireless card would not function) I have not been able to install SQL 2005 nor any of the other apps mentioned in the first line.  The techs who have unrestricted, administrative access also have been unsuccessfull at installing these.  I stand firm that it has to do with security policies; even after having full access (as administrator of local machine).  If I am wrong please explain.  And thank you for any help you can provide.  Below are the error reports I get.

     

    First Report:

    === Verbose logging started: 7/14/2008  10:26:47  Build type: SHIP UNICODE 3.01.4000.4039  Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
    MSI (c) (A0:18) [10:26:47:349]: Resetting cached policy values
    MSI (c) (A0:18) [10:26:47:349]: Machine policy value 'Debug' is 0
    MSI (c) (A0:18) [10:26:47:349]: ******* RunEngine:
               ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (A0:18) [10:26:47:349]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (A0:18) [10:26:47:349]: Grabbed execution mutex.
    MSI (c) (A0:18) [10:26:47:365]: Cloaking enabled.
    MSI (c) (A0:18) [10:26:47:365]: Attempting to enable all disabled priveleges before calling Install on Server
    MSI (c) (A0:18) [10:26:47:365]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (C4:74) [10:26:47:396]: Grabbed execution mutex.
    MSI (s) (C4:68) [10:26:47:396]: Resetting cached policy values
    MSI (s) (C4:68) [10:26:47:396]: Machine policy value 'Debug' is 0
    MSI (s) (C4:68) [10:26:47:396]: ******* RunEngine:
               ******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (C4:68) [10:26:47:396]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (C4:68) [10:26:47:396]: MainEngineThread is returning 1605
    MSI (c) (A0:18) [10:26:47:396]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (A0:18) [10:26:47:396]: MainEngineThread is returning 1605
    === Verbose logging stopped: 7/14/2008  10:26:47 ===

     

     

    Second report:

    Microsoft SQL Server 2005 9.00.1399.06
    ==============================
    OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
    Time            : Mon Jul 14 10:24:19 2008
     
    Machine         : PM08737
    Product         : Microsoft SQL Server Setup Support Files (English)
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLSupport_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server Native Client
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLNCLI_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft Office 2003 Web Components
    Product Version : 11.0.6558.0
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_OWC11_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server 2005 Books Online (English)
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_BOL_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : Microsoft SQL Server 2005 Backward compatibility
    Product Version : 8.05.1054
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_BackwardsCompat_1.log
    --------------------------------------------------------------------------------
    Machine         : PM08737
    Product         : SQLXML4
    Product Version : 9.00.1399.06
    Install         : Successful
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_PM08737_SQLXML4_1.log
    --------------------------------------------------------------------------------

    Monday, July 14, 2008 3:16 PM
  • Hi - not sure if this thread is still active, but ... I've got the same problem. The summary.txt file says :

    Machine         : OFFICE
    Product         : Microsoft SQL Server 2005 Express Edition
    Product Version : 9.3.4035.00
    Install         : Failed
    Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_OFFICE_SQL.log
    Last Action     : InstallFinalize
    Error String    : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is  (1067) The process terminated unexpectedly.
    Error Number    : 29503
    --------------------------------------------------------------------------------

    ... and looking in that log file for the first occurrence of "Value 3" as suggested, I find the following preceding lines ...

    =======================

    Doing Action: Do_sqlScript
    PerfTime Start: Do_sqlScript : Sun Jul 12 12:15:08 2009
    Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Sun Jul 12 12:15:08 2009
    Service failed unexpectedly (1067)
            Error Code: 0x8007042b (1067)
    Windows Error Text: The process terminated unexpectedly.
      Source File Name: sqlsetuplib\service.cpp
    Compiler Timestamp: Sat Oct 25 08:47:19 2008
         Function Name: sqls::Service::Start
    Source Line Number: 301



    ---- Context -----------------------------------------------


    Setting status of unmanaged components and removing unmanaged resources
    Do_sqlScript
    SqlScriptHlpr
    Start service MSSQL$SQLEXPRESS



    Error Code: 1067
    MSI (s) (70!44) [12:15:39:950]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is  (1067) The process terminated unexpectedly.
    .

    Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
    The error is  (1067) The process terminated unexpectedly.
    .
    <Failure Type='Fatal' Error='1067'>
    <EndFunc Name='LaunchFunction' Return='1067' GetLastError='203'>
    MSI (s) (70:A4) [12:15:40:153]: User policy value 'DisableRollback' is 0
    MSI (s) (70:A4) [12:15:40:153]: Machine policy value 'DisableRollback' is 0
    Action ended 12:15:40: InstallFinalize. Return value 3.

    =================================

    ... which leaves me pretty clueless. Any suggestions would be most welcome.

    Thanks.
    • Proposed as answer by December824 Monday, December 14, 2009 4:05 AM
    Sunday, July 12, 2009 11:48 AM