The powershell script is:
Code: Select all
$dbPassword = AI_GetMsiProperty DB_PASSWORD
$errorMessage
$connectionString
if ([string]::IsNullOrEmpty($databaseNamedInstance))
{
$errorMessage = "Database Name cannot be empty!"
}
else
{
if ($useIntegratedSecurity -eq "useIntegratedSecurity")
{
$connectionString = "Server=" + $databaseNamedInstance + ";Database=thisDB;Trusted_Connection=True;MultipleActiveResultSets=true;Encrypt=true;TrustServerCertificate=true;"
}
else
{
if ((-not [string]::IsNullOrEmpty($dbUser)) -and (-not [string]::IsNullOrEmpty($dbPassword)))
{
$connectionString = "Server=" + $databaseNamedInstance + ";Database=thisDB;User id=" + $dbUser + ";Password=" + $dbPassword + ";MultipleActiveResultSets=true;Encrypt=true;TrustServerCertificate=true;"
}
else
{
$errorMessage = "Database username and password cannot be empty if you don't use integrated security"
}
}
}
if (-not [string]::IsNullOrEmpty($errorMessage))
{
AI_SetMsiProperty CHECK_DB_CONNECTION_PARAMETERS "false"
[System.Reflection.Assembly]::LoadWithPartialName('System.Windows.Forms')
[System.Windows.Forms.MessageBox]::Show($errorMessage)
}
else
{
AI_SetMsiProperty CHECK_DB_CONNECTION_PARAMETERS "true"
AI_SetMsiProperty DB_CONNECTION_STRING $connectionString
}
What am I doing wrong?