Not able to install/Uninstall SQL Server Express 2014

Question

I already have SQL Server 2008 pre-installed on my machine then recently installed Visual Studio 2015 which is working fine.

Trying to install express edition of SQL 2014 using following exe:

SQLManagementStudio_x86_ENU

After failed installation attempt, not able to uninstall or reinstall it and receiving 

TITLE: Microsoft SQL Server 2014 Setup===
An error occurred while attempting to create the directory: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014\Configuration Tools

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0xF45F6601%25401201%25401

I am stuck as I am not able to install or uninstall it.

Thanks in Advance!!

Best Regards

Raj Gupta

---

Raj

Answer 1

check prerequisite

https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx

share summary test file

located at %programfiles%\MicrosoftSQL Server\120\Setup Bootstrap\Log\.

To find errors in the summary text file, search the file by using the "error" or "failed" keywords.

---

Please click Mark As Answer if my post helped.

Answer 2

Hello,

Please take ownership of the folder using the following article:

http://www.sevenforums.com/tutorials/1911-take-ownership-shortcut.html

Then retry SQL Server installation. Repeat the take ownership procedure as required.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 3

Excellent!

It worked and able to run the repair installation with all features succeeded & green status :)

Unfortunately when I trying to start Management Studio, throwing below error:

---------------------------
Cannot find one or more components. Please reinstall the application.

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

Let me try restarting my machine now.

Also, please find below the summary log

==========

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2015-12-22 05:24:30
  End time:                      2015-12-22 05:31:30
  Requested action:              Repair

Machine Properties:
  Machine name:                  RAJ-PC
  Machine processor count:       2
  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  Configured
  SQL Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      10.4.6000.29    No         Yes       
  SQL Server 2008                                                          Management Tools - Basic                 1033                 Express Edition      10.4.6000.29    No         Yes       
  SQL Server 2014                                                          Management Tools - Basic                 1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Management Tools - Complete              1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools Connectivity                1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools Backwards Compatibility     1033                 Express Edition      12.0.2000.8     No         Yes       
  SQL Server 2014                                                          Client Tools SDK                         1033                 Express Edition      12.0.2000.8     No         Yes       

Package properties:
  Description:                   Microsoft SQL Server 2014 
  ProductName:                   SQL Server 2014
  Type:                          RTM
  Version:                       12
  SPLevel:                       0
  Installation location:         C:\SQLManagementStudio_x86_ENU\x86\setup\
  Installation edition:          

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 <empty>
  AGTSVCPASSWORD:                <empty>
  AGTSVCSTARTUPTYPE:             Manual
  ASCONFIGDIR:                   Config
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 <empty>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <empty>
  CLTSVCPASSWORD:                <empty>
  CONFIGURATIONFILE:             
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <empty>
  CTLRSVCPASSWORD:               <empty>
  ENU:                           true
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  false
  INDICATEPROGRESS:              false
  INSTANCENAME:                  <empty>
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  QUIET:                         false
  QUIETSIMPLE:                   false
  SQLSVCACCOUNT:                 <empty>
  SQLSVCPASSWORD:                <empty>
  UIMODE:                        AutoAdvance
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20151222_052428\ConfigurationFile.ini

Detailed results:
  Feature:                       Management Tools - Complete
  Status:                        Passed

  Feature:                       Client Tools Connectivity
  Status:                        Passed

  Feature:                       Client Tools SDK
  Status:                        Passed

  Feature:                       Client Tools Backwards Compatibility
  Status:                        Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed

  Feature:                       SQL Client Connectivity
  Status:                        Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed

  Feature:                       Setup Support Files
  Status:                        Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20151222_052428\SystemConfigurationCheck_Report.htm

---

Raj

Answer 4

Hi Raj,

According to your description, you fail to open SQL Server 2014 Management Studio, please perform the following steps to resolve this issue.

  1. Start regedit.exe
  2. Go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio
  3. Delete 12.0_Config
  4. Restart ssms.exe

However, if you still fail to start SSMS 2014, please re-install Visual Studio 2010 Shell as described in below similar blog and thread.
http://klevster.com/fix/sql20122014-management-studio-cannot-find-one-or-more-components-please-reinstall-the-application/
http://stackoverflow.com/questions/27998743/microsoft-sql-server-management-studio-opening-error


Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

---

Lydia Zhang
TechNet Community Support

Answer 5

The .exe file is only having SQL server management studio inside. Take this 

ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe

below

Link

---

Many Thanks & Best Regards, Hua Min