Description
Hi @freddydk , I'm trying to connect to a host SQL Server database that was previously restored from a BACPAC file, instead of using the default container database. While executing the following script, I'm encountering the error shown below.I'm trying to connect to a host SQL Server database that was previously restored from a BACPAC file, instead of using the default container database. While executing the following script, I'm encountering the error shown below.
$databaseParams = @{
"databaseServer" = 'XXXXXX'
"databaseInstance" = 'MSSQLSERVER_BC'
"databaseName" = 'prod'
"databaseCredential" = $credential
"multitenant" = $true
}
New-BcContainer @databaseParams -replaceExternalDatabases -accept_eula
-containerName "bcserver" -artifactUrl (Get-BCArtifactUrl -type OnPrem -version 25.5 -country us)
-memoryLimit 16G -auth NavUserPassword -Credential $credential
-updateHosts -databaseServer "XXXXXX"
-databaseInstance "MSSQLSERVER_BC"
-databaseName "prod" -databaseCredential $databaseCredential
-doNotExportObjectsToText -enableTaskScheduler:$false
-multitenant:$true -databaseConnectionTimeout 120