June 9, 2016 at 7:17 am
Hi guys,
Has anyone installed integration services via command line to an existing SQL Server 2014 instance. This is my script:
Start-Process –Wait -FilePath S:\Setup.exe -ArgumentList '/ConfigurationFile="R:\Installs\<INI File>.ini" /Features=IS /ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /Action=Install /UpdateEnabled=True /UpdateSource="R:\Updates"'
Is there something wrong with this script? The .ini file has the Integration Services option selected but it does not appeared to be checked when I start the install. Where do I specify that IS install should be against the existing SQL instance?
Regards
IC
June 10, 2016 at 1:09 am
can you check what is the configuration.ini file has , please share
June 10, 2016 at 1:30 am
;SQL Server 2014 Configuration File
[OPTIONS]
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.
ACTION="Install"
; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system.
ENU="True"
; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block.
UIMODE="Normal"
; Setup will not display any user interface.
QUIET="False"
; Setup will display progress only, without any user interaction.
QUIETSIMPLE="False"
INSTANCENAME=”MSSQLSERVER”
SQMREPORTING=”False”
INSTANCEID=”MSSQLSERVER”
; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found.
UpdateEnabled="False"
; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature.
ERRORREPORTING="False"
; If this parameter is provided, then this computer will use Microsoft Update to check for updates.
USEMICROSOFTUPDATE="False"
; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server Data Tools, and other shared components.
FEATURES=IS
; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services.
UpdateSource="MU"
; Displays the command line parameters usage
HELP="False"
; Specifies that the detailed Setup log should be piped to the console.
INDICATEPROGRESS="False"
; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system.
X86="False"
; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed.
INSTALLSHAREDDIR="D:\Apps\Microsoft SQL Server"
; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed.
INSTALLSHAREDWOWDIR="D:\Apps\Microsoft SQL Server (x86)"
; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature.
SQMREPORTING="True"
; Specify the installation directory.
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
; Startup type for Integration Services.
ISSVCSTARTUPTYPE="Automatic"
; Account for Integration Services: Domain\User or system account.
ISSVCACCOUNT="NT Service\MsDtsServer120"
June 11, 2016 at 5:29 am
remove the configuration file parameter, if you use the configuration file it will have all the parameter you want to install. so wither you use configuration.ini or remove this file parameter and run with the other option in your command
June 12, 2016 at 10:24 pm
take a look at this article hope this will help you: https://technet.microsoft.com/en-us/library/ms143512(v=sql.90).aspx
June 20, 2016 at 6:23 am
Is this what its supposed to look like?
Start-Process –Wait -FilePath R:\Setup.exe -ArgumentList '/Features=IS ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /UpdateEnabled=True /UpdateSource="D:\Install Files\Updates"'
This does not work. It takes it through the whole install process without automatically selecting Integration services and the Default instance.
June 20, 2016 at 7:18 am
Don't worry. Got it working.
Just needed to change a couple of settings within the .ini file to get it working.
Thanks!
February 14, 2022 at 5:08 pm
Could pls help to share the exact command with .ini file??
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply