navcontainerhelper icon indicating copy to clipboard operation
navcontainerhelper copied to clipboard

BC container problem connecting to the remote SQL database

Open manjunathan-ganesan opened this issue 6 months ago • 2 comments

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

Issue with connecting to remote SQL database

Image

manjunathan-ganesan avatar Jun 20 '25 06:06 manjunathan-ganesan

Hi @FreundDK , Please let me know if you have any suggestions on the above error.

manjunathan-ganesan avatar Jun 23 '25 13:06 manjunathan-ganesan

Related to issue #4037 ?

prosen76 avatar Nov 04 '25 16:11 prosen76

Any updates here? :)

prosen76 avatar Nov 20 '25 14:11 prosen76