SQL IS Parameters - SQL-FineBuild/Common GitHub Wiki
Previous SQL RS Parameters | Tools Parameters Next |
---|
The parameters that are useful for a Integration Services Install are given below. The parameters cover both the basic install and the provisioning that can be performed by SQL FineBuild.
If you are happy that the default value for a given parameter is right for your organisation then you do not need to provide that parameter.
When you run SQL FineBuild you should always provide a /AdminPassword: parameter giving your own password in order to log on automatically after a reboot.
Index
The parameters are divided into the following sections:
- Basic Install
- Account Provisioning
- Cluster Provisioning
- IS Configuration Provisioning
- IS Scaleout Provisioning
Basic Install
Parameter | Default | Comment |
---|---|---|
/SetupSQLIS: | (none) | Set to YES to install Integration Services (DTS for SQL2005) |
The following parameters can normally be left at their default values:
Parameter | Default | Comment |
---|---|---|
/ISSvcStartupType: | Automatic | (SQL2008 and above) SSIS service startup type |
/ISAutoStart: | 1 | (SQL2005 only) SSIS service startup type |
Account Provisioning
Parameter | Default | Comment |
---|---|---|
/IsSvcAccount: | (none) | Name of SSIS Service Account |
/IsSvcPassword: | (none) | Password for SSIS Service Account |
Cluster Provisioning
This section shows the parameters you can add to the Basic Install in order to install a Integration Services Cluster. These parameters are only valid if you are installing on to a Windows Cluster.
Parameter | Default | Comment |
---|---|---|
/SetupSSISCluster: | No | Setup SSIS Cluster |
The following parameters can normally be left at their default values:
Parameter | Default | Comment |
---|---|---|
/ClusISIPSuffix: | (calculated) | TCP final octet for IS Cluster address |
/ClusISSuffix: | IS | Suffix added to Windows Cluster Name to form the Integration Services Cluster Name |
IS Configuration Provisioning
This section shows the parameters you can add to the Basic Install to configure a Integration Services.
Parameter | Default | Comment |
---|---|---|
/SetupSSISDB: | Yes | Install SSIS Catalogue Database |
The following parameters can normally be left at their default values:
Parameter | Default | Comment |
---|---|---|
/SSISDB: | SSISDB | Name of SSIS Catalogue database |
/SSISPassword: | (saPwd) | Password for SSIS Catalog Database |
/SSISRetention: | 30 | Number of days to retain Package History in SSISDB |
IS Scaleout Provisioning
This section shows the parameters you can add to the Basic Install for IS Scaleout for SQL Server 2017 and above.
Parameter | Default | Comment |
---|---|---|
/SetupISMaster: | (none) | Setup IIS Master Scaleout service |
/SetupISWorker: | (none) | Setup IS Worker Scaleout Service |
/IsMasterSvcAccount: | (none) | Name of SSIS Scaleout Master Service Account |
/IsMasterSvcPassword: | (none) | Password for SSIS Scaleout Master Service Account |
/ISMasterSvcThumbprint: | (none) | Tumbprint of IS Master Scaleout Service |
/IsWorkerSvcAccount: | (none) | Name of SSIS Scaleout Worker Service Account |
/ISWorkerSvcCert: | (none) | Path to IS Master certificate file |
/IsWorkerSvcPassword: | (none) | Password for SSIS Scaleout Worker Service Account |
/ISWorkerSVCMaster: | (none) | Name of IS Master Scaleout Service |
The following parameters can normally be left at their default values:
Parameter | Default | Comment |
---|---|---|
/ISMasterSvcStartupType: | Automatic | SSIS Scaleout Master service startup type |
/ISWorkerSvcStartupType: | Automatic | SSIS Scaluout Worker service startup type |
/TCPPortISMaster: | 8391 | TCP Port for IS Master Scaleout Service |
Copyright FineBuild Team © 2021. License and Acknowledgements
Previous SQL RS Parameters | Top | Tools Parameters Next |
---|