Sql-server – Installing SQL Server Integration Services on Server Core

sql serversql server 2014ssiswindows-server

I have Windows Server 2008 R2 Core on virtual machine and want to install SQL Server Integration Services. On the D:/ drive SQL Server 2014 Enterprise .iso is mount.

I am reading a book where it is said that:

You can use the Setup.exe command-line utility to add SSIS to an
existing installation on both traditional and Server Core deployments
of SQL Server 2012. For example, to add the SSIS feature to the
default MSSQLSERVER instance, run the following command:

Setup.exe /qs /Action=Install /Features=IS /InstanceName=MSSQLServer
/IAcceptSQLServerLicenseTerms

but I am getting the following errors:

enter image description here

enter image description here

Could anyone tell what I am doing wrong?

Best Answer

This is from the Administering Microsoft SQL Server 2012 Database book. Make sure you have the initial SQL Server engine installed. Your syntax is exactly right though. I went through it again 10 minutes ago.

Also your ISO is from SQL Server 2014. Try mounting the SQL Server 2012 version.

Related Question