none
Errors trying to install SQL Express 2016 RRS feed

  • Question

  • Trying to install SQL Express 2016 in a W2012r2 Std server that is to be the new DC (yes, I know...) for a small office.  Just needed for a small DB app & current 2008 server runs full SQL 2005 which is too much $$ for this small use.

    Got errors most of the way through install, after it seemed to hang up and say it couldn't find a group by SID.

    Error log makes no sense to me - maybe someone with more SQL experience can figure out what it thinks is wrong so I can fix it, remove SQL, and try again.   Much thanks in advance.  Error log follows:

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2061893606
      Start time:                    2016-08-23 22:28:53
      End time:                      2016-08-23 22:50:57
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for RS:              Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Next step for SQLEngine:       Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Next step for FullText:        Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Next step for AdvancedAnalytics: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Next step for Replication:     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


    Machine Properties:
      Machine name:                  WASH
      Machine processor count:       16
      OS version:                    Microsoft Windows Server 2012 R2 Standard (6.3.9600)
      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
      SPLevel:                       0
      Installation location:         C:\SQLServer2016Media\ExpressAdv\x64\setup\
      Installation edition:          Express

    Product Update Status:
      None discovered.

    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
      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:             
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    true
      ENU:                           true
      EXTSVCACCOUNT:                 NT Service\MSSQLLaunchpad$SQLEXPRESS
      EXTSVCPASSWORD:                <empty>
      FEATURES:                      SQLENGINE, REPLICATION, ADVANCEDANALYTICS, FULLTEXT, RS, CONN, BC, SDK, BOL, SNAC_SDK
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher$SQLEXPRESS
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTROPENLICENSETERMS:      true
      IACCEPTSQLSERVERLICENSETERMS:  true
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             e:\Program Files\Microsoft SQL Server\
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    SQLEXPRESS
      INSTANCENAME:                  SQLEXPRESS
      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:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  NT Service\ReportServer$SQLEXPRESS
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQL$SQLEXPRESS
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           HORIZONPAPER\Administrator
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SQLEXPRESS
      SQLTELSVCPASSWORD:             <empty>
      SQLTELSVCSTARTUPTYPE:          Automatic
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBFILECOUNT:            1
      SQLTEMPDBFILEGROWTH:           64
      SQLTEMPDBFILESIZE:             8
      SQLTEMPDBLOGDIR:               <empty>
      SQLTEMPDBLOGFILEGROWTH:        64
      SQLTEMPDBLOGFILESIZE:          8
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160823_222853\ConfigurationFile.ini

    Detailed results:
      Feature:                       Client Tools Connectivity
      Status:                        Passed

      Feature:                       Client Tools SDK
      Status:                        Passed

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Passed

      Feature:                       Reporting Services - Native
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      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:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      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:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       Full-Text and Semantic Extractions for Search
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      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:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       R Services (In-Database)
      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:                R Services (In-Database)
      Component error code:          0x80131509
      Error description:             Cannot find group with identity S-1-5-21-1957117185-995604489-4217650133-2632.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0x69EA8169%400xE9BC3D64&EvtType=0x69EA8169%400xE9BC3D64
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
      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:          0x851A001A
      Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

      Feature:                       SQL Browser
      Status:                        Passed

      Feature:                       Documentation Components
      Status:                        Passed

      Feature:                       SQL Writer
      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:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160823_222853\SystemConfigurationCheck_Report.htm


    • Edited by WCHBill Wednesday, August 24, 2016 3:50 PM
    Wednesday, August 24, 2016 3:04 AM

Answers

  • Hi WCHBill,

    I’m sensing that the issue could be you are trying to install SQL Server on a DC. Instead of using all default settings during installation, I would suggest you use proper domain accounts as service account during installation see if it fix the issue.

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

    Regards,
    Lin
    • Marked as answer by WCHBill Tuesday, August 30, 2016 5:09 AM
    Wednesday, August 24, 2016 6:14 AM
    Moderator
  • Hi WCHBill,

    According to BOL, you cannot run SQL Services on a domain controller under a local service account so I would suspect that’s the issue. If you could see your instance in SQL Server Configuration Manager, then I would suggest you change the service accounts to domain account see if it helps. If not, I would suggest you uninstall current installation and set service account to domain account during new installation(see attached). 

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

    Regards,
    Lin

    • Marked as answer by WCHBill Tuesday, August 30, 2016 5:09 AM
    Thursday, August 25, 2016 8:15 AM
    Moderator
  • I don't know - the app I need SQL Express to run is 3rd party and I'd have to ask them on Monday.  Maybe I can just ignore it, as you say, if everything else is OK without it.  Thanks.

    There are fairly great chances that R is not needed - this is a new feature in SQL 2016 for advanced analytics.

    BTW - can anyone tell me why I'm not allowed to post images or links - the message says until my account is verified...I did get a message when I opened the account, clicked on the link it contained, but apparently it made no difference.   I can't even "quote" in a reply.

    I decline on the "why" - that is just a source of frustration and confusion. But the place to get it fixed is here:
    https://social.msdn.microsoft.com/Forums/en-US/338e5c21-c7e3-4519-8791-f819535be481/verify-your-account-36?forum=reportabug

    Sunday, August 28, 2016 10:16 AM

All replies

  • Hi WCHBill,

    I’m sensing that the issue could be you are trying to install SQL Server on a DC. Instead of using all default settings during installation, I would suggest you use proper domain accounts as service account during installation see if it fix the issue.

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

    Regards,
    Lin
    • Marked as answer by WCHBill Tuesday, August 30, 2016 5:09 AM
    Wednesday, August 24, 2016 6:14 AM
    Moderator
  • Hi WCHBill,

    I’m sensing that the issue could be you are trying to install SQL Server on a DC. Instead of using all default settings during installation, I would suggest you use proper domain accounts as service account during installation see if it fix the issue.

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

    Regards,
    Lin

    Thanks - my choices were to use Windows authentication only or mixed mode, which I picked, and gave it a password.    So you're saying just do Windows authentication?    Thanks.

    Bill


    Wednesday, August 24, 2016 3:47 PM
  • Hi Bill,

    Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

    Can you please check, if any thing found on SQL Server error log.

    Thanks,


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Wednesday, August 24, 2016 4:08 PM
  • Hi Bill,

    Error description:             Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

    Can you please check, if any thing found on SQL Server error log.

    Thanks,


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Where please do I find that log.   I'm not a SQL person - just do some IT for this office.  Thanks much.   Bill
    Wednesday, August 24, 2016 4:18 PM
  • Hi Bill,

    Open SQL Server Confiuration manager, right click correct instance properties and check the start-up parameters, there you can see the \ERRORLOG location.

    Thanks,


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Wednesday, August 24, 2016 4:35 PM
  • Hi Bill,

    Open SQL Server Confiuration manager, right click correct instance properties and check the start-up parameters, there you can see the \ERRORLOG location.

    Thanks,


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Sorry - I don't think the install got far enough for me to see what you're suggesting.  I'd send you a screen shot but the forum says I can't until my account is "verified" - hasn't prompted me to or sent email to do so.
    • Edited by WCHBill Wednesday, August 24, 2016 5:00 PM
    Wednesday, August 24, 2016 4:59 PM
  • First, the error you are getting: this means that at some point after Setup actually installed SQL Server, it tries to start SQL Server in order to perform further configuration. This fails.

    The path to the folder with the error log would be something like:

    C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\Log

    The exact path depends on choices you made during the setup and which version of SQL Server you installed, but the above should be the path assuming a default installation of SQL 2016 Express.

    We need to see the errorlog to understand why SQL Server does not start.

    Wednesday, August 24, 2016 10:05 PM
  • Sorry Erland, there's absolutely nothing at that location that says "Log" just two folders Install (empty) and Binn (no lon files).   Any other suggestions?   It must show the error somewhere.   Thanks.
    Thursday, August 25, 2016 2:57 AM
  • Sorry Erland, there's absolutely nothing at that location that says "Log" just two folders Install (empty) and Binn (no lon files).   Any other suggestions?   It must show the error somewhere.   Thanks.

    If you came far, I would expect there to be. Unless... Could Setup clean up the installation? Try again, but this time don't stop it or press Cancel.

    You could also search for ERRORLOG in case you selected an alternate location at setup I don't know of.

    Thursday, August 25, 2016 7:31 AM
  • Hi WCHBill,

    According to BOL, you cannot run SQL Services on a domain controller under a local service account so I would suspect that’s the issue. If you could see your instance in SQL Server Configuration Manager, then I would suggest you change the service accounts to domain account see if it helps. If not, I would suggest you uninstall current installation and set service account to domain account during new installation(see attached). 

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

    Regards,
    Lin

    • Marked as answer by WCHBill Tuesday, August 30, 2016 5:09 AM
    Thursday, August 25, 2016 8:15 AM
    Moderator
  • Lin, 

    Well, the Server Configuration Mgr screen doesn't look exactly like your screen shot - and I couldn;t change two of the services anyway.   I've already uninstalled & reinstalled twice - if I do it a third time I'm going to have someone more knowledgeable with me.  Thanks

    Thursday, August 25, 2016 11:48 PM
  • Erland, Nope - no ERRORLOG on the whole machine.  Going to have to regroup. Thanks
    Thursday, August 25, 2016 11:50 PM
  • Bill

    Lin's screenshot is not from the SQL Configuration Manager but from the installation configuration wizard.

    If SQL is already installed then you will get something like this in SQL Configuration Manager:

    

    This will allow you to change the Service Accounts to all run as Domain Accounts.

    If you need to reinstall then you will get the screen that Lin posted and that shows where to set the Domain Accounts for the services to run as.


    Martin Cairney SQL Server MVP

    Friday, August 26, 2016 1:16 AM
  • Martin, yes, I know that, but was still unable to change all the Service Accounts - either didn't take or wasn't offered a choice.  This is SQL Express 2016 BTW, although I'm presuming the screens are just about the same.  Am going to get someone in and try a 3rd reinstall. Thanks.
    Friday, August 26, 2016 1:41 AM
  • Can you confirm which services you were unable to change?    There should not be any restriction in setting these.

    Which components have you installed?  You can restrict it to only the Database Engine if that is all you really need and that will reduce the footprint down to just SQL Server, SQL Agent and SQL Server Browser 

    If you are only connecting locally and using port 1433 then you can stop and disable browser.  Also, SQL Express can't run Agent either so that (if it shows) can be stopped and disabled ... so really you'd only then be looking to set the SQL Server service account appropriately


    Martin Cairney SQL Server MVP


    Friday, August 26, 2016 1:53 AM
  • Martin thanks, but at this point I'm just going to uninstall and start from the top.  It didn't install completely or correctly it seems.  I appreciate your advice.   Bill
    Friday, August 26, 2016 2:14 AM
  • Lin - completely uninstalled SQL Express, including folders, rebooted, re-installed following your advice on using domain accounts.  Failed on R Service - full log too large to post here (don't see how to attach) but relevant part at end is below:

    2016-08-27T18:26:55 INFO Running command: C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\R_SERVICES\\library\RevoScaleR\rxLibs\x64\registerRext.exe /install /sqlbinnpath:"C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\R_SERVICES\\..\MSSQL\Binn" /userpoolsize:0 /instance:"SQLEXPRESS"
    2016-08-27T18:26:56 WARN C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\R_SERVICES\\library\RevoScaleR\rxLibs\x64\registerRext.exe: Command returned exit code -1
    2016-08-27T18:26:56 INFO Exiting with code 5

    ******************

    Also from the install log at end:

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2146233088
      Start time:                    2016-08-27 14:02:17
      End time:                      2016-08-27 14:35:00
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for AdvancedAnalytics: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


    Machine Properties:
      Machine name:                  WASH
      Machine processor count:       16
      OS version:                    Microsoft Windows Server 2012 R2 Standard (6.3.9600)
      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
      SPLevel:                       0
      Installation location:         C:\SQLServer2016Media\ExpressAdv\x64\setup\
      Installation edition:          Express

    Product Update Status:
      None discovered.

    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
      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:             
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    true
      ENU:                           true
      EXTSVCACCOUNT:                 NT Service\MSSQLLaunchpad$SQLEXPRESS
      EXTSVCPASSWORD:                <empty>
      FEATURES:                      SQLENGINE, REPLICATION, ADVANCEDANALYTICS, FULLTEXT, RS, CONN, BC, SDK, BOL, SNAC_SDK
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher$SQLEXPRESS
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTROPENLICENSETERMS:      true
      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:                    SQLEXPRESS
      INSTANCENAME:                  SQLEXPRESS
      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:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  HORIZONPAPER\Administrator
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 HORIZONPAPER\Administrator
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           HORIZONPAPER\Administrator
      SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SQLEXPRESS
      SQLTELSVCPASSWORD:             <empty>
      SQLTELSVCSTARTUPTYPE:          Automatic
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBFILECOUNT:            1
      SQLTEMPDBFILEGROWTH:           64
      SQLTEMPDBFILESIZE:             8
      SQLTEMPDBLOGDIR:               <empty>
      SQLTEMPDBLOGFILEGROWTH:        64
      SQLTEMPDBLOGFILESIZE:          8
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160827_140216\ConfigurationFile.ini

    Detailed results:
      Feature:                       Client Tools Connectivity
      Status:                        Passed

      Feature:                       Client Tools SDK
      Status:                        Passed

      Feature:                       Client Tools Backwards Compatibility
      Status:                        Passed

      Feature:                       Reporting Services - Native
      Status:                        Passed

      Feature:                       Database Engine Services
      Status:                        Passed

      Feature:                       Full-Text and Semantic Extractions for Search
      Status:                        Passed

      Feature:                       R Services (In-Database)
      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 error code:          0x80131500
      Error description:             R Install failed. Check /logfile "C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160827_140216\RSetup.log" for details.
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0x0C040519%400xC68B78F0&EvtType=0x0C040519%400xC68B78F0

      Feature:                       SQL Server Replication
      Status:                        Passed

      Feature:                       SQL Browser
      Status:                        Passed

      Feature:                       Documentation Components
      Status:                        Passed

      Feature:                       SQL Writer
      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:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160827_140216\SystemConfigurationCheck_Report.htm


    Saturday, August 27, 2016 9:25 PM
  • Do you need support for R? Else you could let this slip.
    Did you check:
    "C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160827_140216\RSetup.log" for details?

    Saturday, August 27, 2016 9:31 PM
  • I don't know - the app I need SQL Express to run is 3rd party and I'd have to ask them on Monday.  Maybe I can just ignore it, as you say, if everything else is OK without it.  Thanks.

    BTW - can anyone tell me why I'm not allowed to post images or links - the message says until my account is verified...I did get a message when I opened the account, clicked on the link it contained, but apparently it made no difference.   I can't even "quote" in a reply.

    Bill

    Saturday, August 27, 2016 9:41 PM
  • I don't know - the app I need SQL Express to run is 3rd party and I'd have to ask them on Monday.  Maybe I can just ignore it, as you say, if everything else is OK without it.  Thanks.

    There are fairly great chances that R is not needed - this is a new feature in SQL 2016 for advanced analytics.

    BTW - can anyone tell me why I'm not allowed to post images or links - the message says until my account is verified...I did get a message when I opened the account, clicked on the link it contained, but apparently it made no difference.   I can't even "quote" in a reply.

    I decline on the "why" - that is just a source of frustration and confusion. But the place to get it fixed is here:
    https://social.msdn.microsoft.com/Forums/en-US/338e5c21-c7e3-4519-8791-f819535be481/verify-your-account-36?forum=reportabug

    Sunday, August 28, 2016 10:16 AM