Genpact Cora Knowledge Center

Support

PowerShell Function: Set-CoraSeQuenceConnectionString

V9.6

Supported only for V9.x deployments.

Module

CoraSeQuence

Description

Sets the connection string to the database for all the applications deployed on the server in the Administration Web.config.

Syntax

Set-CoraSeQuenceConnectionString -SQLServer <String> -Database <String> [-EncryptedCredentials <String>] [-Properties <Hashtable>] -ApplicationType <String> [-ApplicationID <Int32>] [-AllInstances] [<CommonParameters>]
Set-CoraSeQuenceConnectionString -SQLServer <String> -Database <String> [-EncryptedCredentials <String>] [-Properties <Hashtable>] [<CommonParameters>]

Parameters

-SQLServer <String>

The name of the SQL server. Standard format, including instance name and port, if not default.

Required?true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters?  false


-Database<String>

The name of the Cora SeQuence database.

Required?true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters?  false


-EncryptedCredentials<string>

The Cora SeQuence-encrypted credentials (username and password). Use the Cora SeQuence Toolkit to encrypt, if needed. If not provided, connectionstring will be set with Integrated Security=SSPI.

Required?false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters?  false


-Properties <Hashtable>

Hashtable of properties to add to the default connectionstring. Existing keys in the default connectionstring will be overwritten.

Required?false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters?  false


-ApplicationType <String>

Sets the connection string to a specific type of application.

Required?true
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters?  false


-ApplicationID <Int32>

Sets the numeric ID for a specific instance of the application type to set. Ignored if AllInstances is used.

Required?false
Position? named
Default value1
Accept pipeline input? false
Accept wildcard characters?  false


-AllInstances [<SwitchParameter>]

Sets the connection string to all instances of the specified application.

Required?false
Position? named
Default valueFalse
Accept pipeline input? false
Accept wildcard characters?  false


<CommonParameters>

This command supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.  


Example

PS C:\>Set-CoraSeQuenceConnectionString -SQLServer "MySQLServer" -Database "Sequence" -EncryptedCredentials "dOtg/dWG6Q1TJDAvqHLX6SkR33ArkTNyMEYXCBgOjU0RCQnHmN5ZNwfKciBh6dXKChuYGO8X4Y5nUAoHQ3S3tw=="


V9.0

Module

CoraSeQuence

Description

Sets the connection string to the database for all the applications deployed on the server in the Administration Web.config.

Syntax

Set-CoraSeQuenceConnectionString [-SQLServer] <String> [-Database] <String> [[-EncryptedCredentials] <String>] [[-Properties] <Hashtable>] [<CommonParameters

Parameters

-SQLServer <String>

The name of the SQL server. Standard format, including instance name and port, if not default.

Required?true
Position? 1
Default value
Accept pipeline input? false
Accept wildcard characters?  false

-Database<String>

The name of the Cora SeQuence database.

Required?true
Position? 2
Default value
Accept pipeline input? false
Accept wildcard characters?  false

-EncryptedCredentials<string>

The Cora SeQuence-encrypted credentials (username and password). Use the Cora SeQuence Toolkit to encrypt, if needed. If not provided, connectionstring will be set with Integrated Security=SSPI.

Required?false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters?  false

-Properties <Hashtable>

Hashtable of properties to add to the default connectionstring. Existing keys in the default connectionstring will be overwritten.

Required?false
Position? 4
Default value
Accept pipeline input? false
Accept wildcard characters?  false

<CommonParameters>

This command supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.  


Example

PS C:\>Set-CoraSeQuenceConnectionString -SQLServer "MySQLServer" -Database "Sequence" -EncryptedCredentials "dOtg/dWG6Q1TJDAvqHLX6SkR33ArkTNyMEYXCBgOjU0RCQnHmN5ZNwfKciBh6dXKChuYGO8X4Y5nUAoHQ3S3tw=="