Cora Knowledge Center

Support

PowerShell Function: Set-CoraSeQuenceConnectionString

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