Features are missing installing MS SQL SERVER 2016 with SQL Server R Services using web installer and command line

Question

I am trying to install MS SQL SERVER 2016 with SQL Server R Services using web installer and command line. I am doing this based on this article https://msdn.microsoft.com/en-us/library/mt695943.aspx

Using same web installer, but not command line works perfectly. All desired features are there. Problem is that command line installation installs only SQLEngine and Replication features. Logs investigation does not help much. It seems that proper files have not been downloaded and this is the reason why they are missing

My command line is:

SQLServer2016-SSEI-Expr.exe /ConfigurationFile=C:\temp\configuration.ini /IACCEPTSQLSERVERLICENSETERMS /MediaPath=C:\SQLSetup /ENU

And the configuration file content is

 [OPTIONS]
 Action=Install
 INSTANCENAME=MSSQL2016
 FEATURES=SQL,AdvancedAnalytics
 IACCEPTROPENLICENSETERMS
 SECURITYMODE=SQL
 SQLSYSADMINACCOUNTS="<username>"
 SAPWD="%password%"

What am I doing wrong?

Update: Logs: https://dl.dropboxusercontent.com/u/3028367/20161005_093914.zip

Update 2: I think I have found the reason for missing files When I run SQLServer2016-SSEI-Expr.exe /? I get this out put:

Optional settings for basic install
==================================

D:\Downloads\SQLServer2016-SSEI-Expr.exe [/ConfigurationFile=C:\Configuration.ini] [/IAcceptSqlServerLicenseTerms] [/Med
iaPath=C:\SqlServer2016Setup] [/ENU]

ConfigurationFile              Specifies the ConfigurationFile to use.
IAcceptSqlServerLicenseTerms   Required to acknowledge acceptance of the license terms.
MediaPath                      Location where SQL Server setup media will be downloaded and extracted to.
ENU                            Use this parameter to install the English version of SQL Server on a localized operating
system.

"Basic!" I need "custom" It is available with the same installer if I use UI

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

It seems your INI file asks SQLServer to install only few features like SQLEngine and analytics.

when you specify

FEATURES=SQL,Tools

SQL will install..

. The SQL feature will install the database engine, replication, and full-text. The Tools feature will install Management Tools, Books online, SQL Server Data Tools, and other shared components

when you specify

FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,IS,BC,SDK,SSMS,ADV_SSMS,OCS

It will install all the above mentioned features

so you might be missing some features due to the way you are specifying

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 05 '16 at 13:59

TheGameiswar

27,855
8
56
94

I'll try now, but https://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature says "SQL: Installs the SQL Server Database Engine, Replication, Fulltext, and Data Quality Server" – Alexey Korsakov Oct 06 '16 at 05:10
can you post set up log as well – TheGameiswar Oct 06 '16 at 05:29

score 0 · Accepted Answer · answered Oct 17 '16 at 08:32

0

Due to this article https://support.microsoft.com/en-us/kb/3192738 only basic installation is supported by web installer, at least at this point

answered Oct 17 '16 at 08:32

Alexey Korsakov

192
1
14

Features are missing installing MS SQL SERVER 2016 with SQL Server R Services using web installer and command line

2 Answers2