locked
Not able to install/Uninstall SQL Server Express 2014 RRS feed

  • 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

    Sunday, December 20, 2015 2:09 PM

Answers

All replies

  • 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.

    Sunday, December 20, 2015 4:40 PM
  • 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

    Sunday, December 20, 2015 8:13 PM
  • 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

    Tuesday, December 22, 2015 12:08 AM
  • 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



    Wednesday, December 23, 2015 5:58 AM
  • 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

    Wednesday, December 23, 2015 6:11 AM