MSSQL Target Connector CLI Configuration

This topic contains the parameters for adding MSSQL target applications and target accounts:
capam32
This topic contains the parameters for adding MSSQL target applications and target accounts:
2
MSSQL Target Application CLI Parameters
To add an MSSQL target application and connector using the CLI, use the addTargetApplication command and the following command parameters:
TargetApplication.type
The target application connector type.
Required
Default Value
Valid Values
yes
N/A
mssql
Attribute.extensionType
Required
Default Value
Valid Values
yes
N/A
mssql
Attribute.sslEnabled
Required
Default Value
Valid Values
false
true, false
Attribute.port
The target application port.
Required
Default Value
Valid Values
no
N/A
0-65535. The GUI uses default value 1433
Attribute.instance
The database instance name.
Required
Default Value
Valid Values
no
N/A. If an instance is not specified, the target connector connects with the default database instance.
String.
MSSQL Target Account CLI Parameters
To add an MSSQL target account that uses the target connector, use the addTargetAccount command and the following command parameters:
Attribute.useOtherAccountToChangePassword
Specifies whether to use the target account or a different account to perform password change requests.
Required
Default Value
Valid Values
yes
N/A
true, false
Attribute.otherAccount
Specifies which other account to use to perform password change requests.
Required
Default Value
Valid Values
yes if
Attribute.useOtherAccountToChangePassword
is true.
N/A
A valid target account ID.
MSSQL CLI Example
cmdName=addTargetApplication TargetServer.hostName=myhostname.mydomain.com
TargetApplication.name=myMSsql TargetApplication.type=mssql
Attribute.extensionType=mssql Attribute.port=1433
cmdName=addTargetAccount TargetServer.hostName=myhostname.mydomain.com
TargetApplication.name=myMSsql TargetAccount.userName=admin TargetAccount.password=p@ssw0rd
TargetAccount.cacheBehavior=useCacheFirst TargetAccount.cacheDuration=21
Attribute.useOtherAccountToChangePassword=false