-
Notifications
You must be signed in to change notification settings - Fork 10
SQL IS Parameters
| 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.
The parameters are divided into the following sections:
- Basic Install
- Account Provisioning
- Cluster Provisioning
- IS Configuration Provisioning
- IS Scaleout Provisioning
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLIS: | (none) | Set to YES to install Integration Services (DTS for SQL2005) |
The following basic install parameters do not normally need to be changed:
| Parameter | Default | Comment |
|---|---|---|
| /ISSvcStartupType: | Automatic | (SQL2008 and above) SSIS service startup type |
| /ISAutoStart: | 1 | (SQL2005 only) SSIS service startup type |
| Parameter | Default | Comment |
|---|---|---|
| /IsSvcAccount: | (none) | Name of SSIS Service Account |
| /IsSvcPassword: | (none) | Password for SSIS Service Account |
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 cluster parameters do not normally need to be changed:
| 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 |
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 |
| /SSISDB: | SSISDB | Name of SSIS Catalogue database |
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 |
| /ISMasterSvcStartupType: | Automatic | SSIS Scaleout Master service startup type |
| /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 |
| /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 |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP