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-CoraSeQuenceServicesConnectionString -SQLServer "MySQLServer" -Database "Sequence" -EncryptedCredentials "dOtg/dWG6Q1TJDAvqHLX6SkR33ArkTNyMEYXCBgOjU0RCQnHmN5ZNwfKciBh6dXKChuYGO8X4Y5nUAoHQ3S3tw=="
