Microsoft SQL Server Express Edition (SQL Server 2008 R2 Express) install problem on Windows 7

Question

So for the last 2 days I've been trying to install SQL Server 2008 r2 Express with no success. After many many tries I'm ready to give up. I've tried everithing from searching the forums to reinstalling windows 7- nothing worked. Here's the closest I got. When the instalation is 90% finished I get a popup messege saying: 

The following error has occured:

External component has thrown an exception

Clicking on the help button next to the text I get a little more details

LinkID 20476

Product Name Microsoft SQL Server

Message Source setup.rll

Message ID 50000

Product Version 10.50.1600.1

EvtType 0xC6CA5DB2%400x7FCCE689

This is a screen of the instalation

Here's the 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):           2144134793

  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:                    2011-09-22 20:45:13

  End time:                      2011-09-22 20:57:49

  Requested action:              Install

Machine Properties:

  Machine name:                  RAZVANESCU-PC

  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:               x86

  Process architecture:          32 Bit

  OS clustered:                  No

Product features discovered:

  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

  Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      10.1.2531.0     No        

  Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      10.1.2531.0     No        

Package properties:

  Description:                   SQL Server Database Services 2008 R2

  ProductName:                   SQL Server 2008 R2

  Type:                          RTM

  Version:                       10

  SPLevel:                       0

  Installation location:         e:\ad3ac50c0946ff0d8b63bdc1aed2\x86\setup\

  Installation edition:          EXPRESS_ADVANCED

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,SSMS

  FILESTREAMLEVEL:               0

  FILESTREAMSHARENAME:           <empty>

  FTSVCACCOUNT:                  <empty>

  FTSVCPASSWORD:                 *****

  HELP:                          False

  IACCEPTSQLSERVERLICENSETERMS:  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:                    MSSQLSERVER

  INSTANCENAME:                  MSSQLSERVER

  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService

  ISSVCPASSWORD:                 *****

  ISSVCSTARTUPTYPE:              Automatic

  NPENABLED:                     0

  PASSPHRASE:                    *****

  PCUSOURCE:                     

  PID:                           *****

  QUIET:                         False

  QUIETSIMPLE:                   False

  ROLE:                          AllFeatures_WithDefaults

  RSINSTALLMODE:                 FilesOnlyMode

  RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE

  RSSVCPASSWORD:                 *****

  RSSVCSTARTUPTYPE:              Automatic

  SAPWD:                         *****

  SECURITYMODE:                  <empty>

  SQLBACKUPDIR:                  <empty>

  SQLCOLLATION:                  Danish_Norwegian_CI_AS

  SQLSVCACCOUNT:                 razvanescu

  SQLSVCPASSWORD:                *****

  SQLSVCSTARTUPTYPE:             Automatic

  SQLSYSADMINACCOUNTS:           razvanescu-PC\razvanescu

  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\20110922_204436\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:      0x7FCCE689

  Configuration error description: External component has thrown an exception.

  Configuration log:             c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110922_204436\Detail.txt

  Feature:                       Management Tools - Basic

  Status:                        Passed

  MSI status:                    Passed

  Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110922_204436\SystemConfigurationCheck_Report.htm

Not sure if the above log helpes. Hope you can shed some light over this because I'm ready to give up. 

Answer 1

Have you had a look at the bootstrap files to see if they give any further information. The result given above just outlines the components that are being installed and does not give any indication onto the error that you are getting.

With this being on WIndows 7 Have you disabled UAC ? http://www.mydigitallife.info/how-to-disable-and-turn-off-uac-in-windows-7/

When you run the installation have you run the setup.exe with the Run as Administrator ?

Anything more at this point would be taking a stab in the dark due to no further information.

---

Warwick Rudd
MCT MCITP SQL Server 2008 Admin
My Blog

Answer 2

Hi razvanescu,

Please read through Hardware and Software Requirements for Installing SQL Server 2008 R2 to make sure your machine meets the requirement before installation.  Reference: http://msdn.microsoft.com/en-us/library/ms143506.aspx.

 

Make sure you download SQL Server 2008 R2 Express from the proper link http://www.microsoft.com/download/en/details.aspx?id=3743.

You need to follow below steps:

Step 1: Download and install Microsoft .Net Framework 3.5 SP1. Or Download and install Microsoft .Net Framework 4.0.
Step 2: Download and install Windows Installer 4.5.
Step 3: Download SQL Server 2008 R2 Express by clicking the appropriate link.

For further investigation, please post the error message in c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110922_204436\Detail.txt.

Here is link about how to view and read SQL Server Setup Log Files:
 http://msdn.microsoft.com/en-us/library/ms143702.aspx

 

Hope this helps.
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 3

Hi I have the same problem as you and I find the solution, I have. frameork net 4.0, windows installer 5.0  and I get the exception of the external component, no longer do I have searched a lot and can not find the solution, I hope they can help thanks

 

Answer 4

Yes imanol17 that's the same problem I had. 

I did manage to install it after after reinstalling Windows 7 (that's the only thing that worked for me).

Maggie Luo the steps you mentioned in your reply don't really apply to my problem because I have windows 7 installed (as I mentioned in my post) which contains  Microsoft .Net Framework 3.5 SP1 and Windows Installer 4.5. Also my computer is quite high end and the software is up to date.

Warwick Rudd I didn't post the bootstrap log file because it was gigantic and didn't fit in the page :).

Hope somebody finds a viable solution to this problem since reinstalling windows is one of the things I hate most. 

 

Answer 5

Hi All,

   Even i am also facing the same issue, but still i can't find the root cause. Could any body know about this issue please share with 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):           2144134793
  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-27 02:07:21
  End time:                      2013-03-27 02:12:04
  Requested action:              Install

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

Thanks in Advance!!!!!!

Thanks & Regards,

Reddy