Skip to content

BC container problem connecting to the remote SQL database #3967

Open
@manjunathan-ganesan

Description

@manjunathan-ganesan

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions