Semicolon in credential breaks connection string

[tietoevry-camperap]

Environment:

SqlServer PowerShell Module version: 22.4.5.1 OS: Microsoft Windows Server 2016 Standard OS: Version: 10.0.14393 Build 14393 PS Version: 5.1.14393.8330

Problem:

Password with semicolon is treated as separator in connection string generation, not escaped.

Example invocations:

Invoke-ASCmd -InputFile "$xmlaPath" -Server "$Server" -Credential $SSASCreds

Invoke-ProcessCube -Name "$Cube" -Database "$Database" -ProcessType ProcessFull -Server "$Server" -Credential $SSASCreds

Inputs:

$SSASCreds = [System.Management.Automation.PSCredential]::New("myuser", (ConvertTo-SecureString "MyPass;HasASemicolon" -AsPlainText -Force))