V9.6
Supported only for V9.x deployments.
Module
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 value | 1 |
| 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 value | False |
| 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
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=="
