none
Install Failure of SQL 2016 Standard - The Process cannot access the file...

    Question

  • Hello,

    A little history - I have a new computer and installed SQL Server 2016 Express to do a demo. I have recently purchased SQL Server 2016 Standard to put on this same computer. I was told that I needed to uninstall the Express version first. I did so, rebooted then started the install of the Standard version. I have tried this at least a half dozen times over many hours now and get the following error. I need some help getting past this issue please...

    Could not past the screenshot so below is what was in the log.

    Thanks,

    Dan

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2068119551
      Start time:                    2017-03-30 09:50:12
      End time:                      2017-03-30 09:55:51
      Requested action:              Install
    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

    Machine Properties:
      Machine name:                  DESKTOP-5OO4IUA
      Machine processor count:       4
      OS version:                    Microsoft Windows 10 Home (10.0.14393)
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No
    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
    Package properties:
      Description:                   Microsoft SQL Server 2016
      ProductName:                   SQL Server 2016
      Type:                          RTM
      Version:                       13
      Installation location:         C:\Temp\Evaluation\x64\setup\
      Installation edition:          Standard
      Slipstream:                    True
      SP Level                       1
    Product Update Status:
      Success: KB 3182545
    Product Updates Selected for Installation:
      Title:                         Microsoft SQL Server 2016  with SP1
      Knowledge Based Article:       KB 3182545
      Version:                       13.1.4001.0
      Architecture:                  x64
      Language:                      1033
      Update Source:                 Slipstream

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTELSVCACCT:                  <empty>
      ASTELSVCPASSWORD:              <empty>
      ASTELSVCSTARTUPTYPE:           0
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   <empty>
      CLTRESULTDIR:                  <empty>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <empty>
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 <empty>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170330_095010\ConfigurationFile.ini
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    false
      ENU:                           true
      EXTSVCACCOUNT:                 <empty>
      EXTSVCPASSWORD:                <empty>
      FEATURES:                      SQLENGINE
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTROPENLICENSETERMS:      false
      IACCEPTSQLSERVERLICENSETERMS:  true
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      ISTELSVCACCT:                  <empty>
      ISTELSVCPASSWORD:              <empty>
      ISTELSVCSTARTUPTYPE:           0
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      MRCACHEDIRECTORY:             
      NPENABLED:                     0
      PBDMSSVCACCOUNT:               <empty>
      PBDMSSVCPASSWORD:              <empty>
      PBDMSSVCSTARTUPTYPE:           0
      PBENGSVCACCOUNT:               <empty>
      PBENGSVCPASSWORD:              <empty>
      PBENGSVCSTARTUPTYPE:           0
      PBPORTRANGE:                   <empty>
      PBSCALEOUT:                    false
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                         
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           DESKTOP-5OO4IUA\dgust
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY
      SQLTELSVCPASSWORD:             <empty>
      SQLTELSVCSTARTUPTYPE:          Automatic
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBFILECOUNT:            4
      SQLTEMPDBFILEGROWTH:           64
      SQLTEMPDBFILESIZE:             8
      SQLTEMPDBLOGDIR:               <empty>
      SQLTEMPDBLOGFILEGROWTH:        64
      SQLTEMPDBLOGFILESIZE:          8
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      TCPENABLED:                    1
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  Slipstream
      USEMICROSOFTUPDATE:            false
      X86:                           false
      Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170330_095010\ConfigurationFile.ini
    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred during the setup process of the feature.
      Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          0x84BB0001
      Error description:             The process cannot access the file 'C:\Users\dgust\AppData\Local\Temp\sqlctr-(c951a57e-6743-43d9-8726-5dfe86a14834).ini' because it is being used by another process.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x60797DC7%400x24C2C4E7&EvtType=0x60797DC7%400x24C2C4E7
      Feature:                       SQL Browser
      Status:                        Passed
      Feature:                       SQL Writer
      Status:                        Passed
      Feature:                       SQL Client Connectivity
      Status:                        Passed
      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
    Rules with failures:
    Global rules:
    Scenario specific rules:
    Rules report file:               C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170330_095010\SystemConfigurationCheck_Report.htm

    Thursday, March 30, 2017 2:09 PM

Answers

  •   Error description:             The process cannot access the file 'C:\Users\dgust\AppData\Local\Temp\sqlctr-(c951a57e-6743-43d9-8726-5dfe86a14834).ini' because it is being used by another process.

    Hello,

    Is there may a anti-Virus Software running, which blocks the access on this file? You could temporary turn it off for installation.

    Have you startet the installer with local admin permissions?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:39 AM
    Thursday, March 30, 2017 2:19 PM
  • Hi dgustavsen,

    >>I just tried both and still have the same error.

    So, something is still holding the file, have you tried restart your computer? If the issue persists after restart, could you please follow the instructions here to use Process Explorer to find out what is holding the file?

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:40 AM
    Friday, March 31, 2017 6:11 AM
    Moderator
  •  

    Hi dgustavsen,

    Please check Firewall also and if it is on, temporary turn it off.

    Thanks DKG.

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:40 AM
    Friday, March 31, 2017 6:16 AM

All replies

  •   Error description:             The process cannot access the file 'C:\Users\dgust\AppData\Local\Temp\sqlctr-(c951a57e-6743-43d9-8726-5dfe86a14834).ini' because it is being used by another process.

    Hello,

    Is there may a anti-Virus Software running, which blocks the access on this file? You could temporary turn it off for installation.

    Have you startet the installer with local admin permissions?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:39 AM
    Thursday, March 30, 2017 2:19 PM
  • All great points Olaf. I will try both now.

    Dan

    Thursday, March 30, 2017 3:35 PM
  • I just tried both and still have the same error.
    Thursday, March 30, 2017 3:48 PM
  • Hi dgustavsen,

    >>I just tried both and still have the same error.

    So, something is still holding the file, have you tried restart your computer? If the issue persists after restart, could you please follow the instructions here to use Process Explorer to find out what is holding the file?

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:40 AM
    Friday, March 31, 2017 6:11 AM
    Moderator
  •  

    Hi dgustavsen,

    Please check Firewall also and if it is on, temporary turn it off.

    Thanks DKG.

    • Marked as answer by dgustavsen Friday, March 31, 2017 11:40 AM
    Friday, March 31, 2017 6:16 AM
  • Hello,

    Thank you for the replies... after looking deeper at the anti-virus and firewalls, I turned off McAfee anti-virus and fire wall as I did before. Then I noticed Avast Antivirus was on this pc as well. Since it's a new computer I though it was a free trial waiting to be installed, however I saw it running in the task manager. I went into that application and turned everything off in there as well.

    After turning off everything in McAfee AND Avast, the install finally worked - only a day wasted!

    Thanks again for all the suggestions!

    Dan

    Friday, March 31, 2017 11:44 AM