search

microsoft / navcontainerhelper

Official Microsoft repository for BcContainerHelper, a PowerShell module, which makes it easier to work with Business Central Containers on Docker.
MIT License
385 stars 246 forks source link

Business Central Docker External SQL #2668

Closed marioolleshi closed 1 year ago

marioolleshi commented 2 years ago

Script used to create container and cause the issue

$containerName = 'bc20'
$credential = Get-Credential -Message 'Using UserPassword authentication. Please enter credentials for the container.'
$auth = 'UserPassword'
$artifactUrl = Get-BcArtifactUrl -type 'OnPrem' -country 'w1' -select 'Latest'
$databaseServer = 'host.containerhelper.internal'
$databaseInstance = ''
$databaseName = 'test'
$databaseUsername = 'sa'
$databaseSecurePassword = ConvertTo-SecureString -String $databasePassword -AsPlainText -Force
$databaseCredential = New-Object pscredential $databaseUsername, $databaseSecurePassword
$licenseFile = 'C:\Users\MarjoLleshi\Desktop\lic\BC20.flf'
New-BcContainer `
    -accept_eula `
    -containerName $containerName `
    -credential $credential `
    -auth $auth `
    -artifactUrl $artifactUrl `
    -databaseServer $databaseServer -databaseInstance $databaseInstance -databaseName $databaseName `
    -databaseCredential $databaseCredential `
    -assignPremiumPlan `
    -licenseFile $licenseFile `
    -memoryLimit 14G `
    -updateHosts

Full output of script

BcContainerHelper is version 3.0.11
BcContainerHelper is running as administrator
Hyper-V is Enabled
UsePsSession is True
Host is Microsoft Windows 10 Pro - 21H2
Docker Client Version is 20.10.17
Docker Server Version is 20.10.17
Removing Session bc20
Removing container bc20
Removing entries from hosts
Removing bc20 from container hosts file
Removing bc20-* from container hosts file
Removing Desktop shortcuts
Removing C:\ProgramData\BcContainerHelper\Extensions\bc20
Fetching all docker images
Fetching all docker volumes
INFO: Windows 10 21H1/21H2 images are not yet available, using 2004 as these are found to work better than 20H2 on 21H1/21H2
Using image mcr.microsoft.com/businesscentral:10.0.19041.1415
Creating Container bc20
Style: onprem
Multitenant: No
Version: 20.4.44313.44365
Platform: 20.0.44266.44359
Generic Tag: 1.0.2.13
Container OS Version: 10.0.19041.1415 (2004)
Host OS Version: 10.0.19044.1889 (21H2)
WARNING: Host OS is 21H1 and Container OS is 2004, defaulting to process isolation. If you experience problems, add -isolation hyperv.
Using process isolation
Using locale en-US
Disabling the standard eventlog dump to container log every 2 seconds (use -dumpEventLog to enable)
Using license file C:\Users\MarjoLleshi\Desktop\lic\BC20.flf
Files in C:\ProgramData\BcContainerHelper\Extensions\bc20\my:
- AdditionalOutput.ps1
- license.flf
- MainLoop.ps1
- SetupVariables.ps1
- updatehosts.ps1
Creating container bc20 from image mcr.microsoft.com/businesscentral:10.0.19041.1415
82790c4f6e5af81188ceaf1b02f0a23bf67886819edcd1767e165c5205a7d791
Waiting for container bc20 to be ready
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.4.44313.44365/w1
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\Program Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.4.44313.44365\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.4.44313.44365\platform
c:\dl\onprem\20.4.44313.44365\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.4.44313.44365\platform\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.4.44313.44365\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.4.44313.44365\platform\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.4.44313.44365/w1
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\Program Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.4.44313.44365\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.4.44313.44365\platform
c:\dl\onprem\20.4.44313.44365\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.4.44313.44365\platform\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.4.44313.44365\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.4.44313.44365\platform\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 19 seconds
Installation complete
Initializing...
Setting host.docker.internal to 10.55.52.52 in container hosts file (copy from host hosts file)
Setting gateway.docker.internal to 10.55.52.52 in container hosts file (copy from host hosts file)
Setting kubernetes.docker.internal to 127.0.0.1 in container hosts file (copy from host hosts file)
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bc20
PublicDnsName is bc20
WARNING: DNS resolution not working from within the container.
Using NavUserPassword Authentication
Stopping local SQL Server
Creating Self Signed Certificate
Self Signed Certificate Thumbprint 120FF87015BCCAFD055EBF341F205A30AFC2768D
DNS identity bc20
Modifying Service Tier Config File with Instance Specific Settings
Starting Service Tier
Failed to start service 'Dynamics 365 Business Central Server [BC] (MicrosoftDynamicsNavServer$BC)'.
at <ScriptBlock>, C:\Run\navstart.ps1: line 172
at <ScriptBlock>, C:\Run\start.ps1: line 384
at <ScriptBlock>, <No file>: line 1Error
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.4.44313.44365/w1
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\Program Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.4.44313.44365\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.4.44313.44365\platform
c:\dl\onprem\20.4.44313.44365\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.4.44313.44365\platform\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.4.44313.44365\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.4.44313.44365\platform\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.4.44313.44365/w1
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\Program Files
c:\dl\onprem\20.4.44313.44365\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.4.44313.44365\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.4.44313.44365\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.4.44313.44365\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.4.44313.44365\platform
c:\dl\onprem\20.4.44313.44365\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.4.44313.44365\platform\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.4.44313.44365\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.4.44313.44365\platform\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 19 seconds
Installation complete
Initializing...
Setting host.docker.internal to 10.55.52.52 in container hosts file (copy from host hosts file)
Setting gateway.docker.internal to 10.55.52.52 in container hosts file (copy from host hosts file)
Setting kubernetes.docker.internal to 127.0.0.1 in container hosts file (copy from host hosts file)
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bc20
PublicDnsName is bc20
WARNING: DNS resolution not working from within the container.
Using NavUserPassword Authentication
Stopping local SQL Server
Creating Self Signed Certificate
Self Signed Certificate Thumbprint 120FF87015BCCAFD055EBF341F205A30AFC2768D
DNS identity bc20
Modifying Service Tier Config File with Instance Specific Settings
Starting Service Tier
Failed to start service 'Dynamics 365 Business Central Server [BC] (MicrosoftDynamicsNavServer$BC)'.
at <ScriptBlock>, C:\Run\navstart.ps1: line 172
at <ScriptBlock>, C:\Run\start.ps1: line 384
at <ScriptBlock>, <No file>: line 1
New-BcContainer Telemetry Correlation Id: 982d1fdc-201e-486a-b456-903b2c10eba6
Initialization of container bc20 failed
At C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\3.0.11\ContainerHandling\Wait-NavContainerReady.ps1:42 char:17
+ ...             throw "Initialization of container $containerName failed" ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Initialization of container bc20 failed:String) [], RuntimeException
    + FullyQualifiedErrorId : Initialization of container bc20 failed
...
What am I missing ?
freddydk commented 2 years ago

You should always use the latest containerhelper when creating issues.

Did you restore the database to the SQL Server on the host manually? You can use Get-BcContainerEventLog to get the eventlog from the container and see why the service tier didn't start. I use this script to spin up a container with the database placed on the host computer:

$artifactUrl = Get-BCArtifactUrl -country us -type OnPrem
$cred = New-Object PSCredential -ArgumentList 'admin', $PasswordSecret.SecretValue
$sqlcred = New-Object PSCredential -ArgumentList 'sa', $PasswordSecret.SecretValue
$containerName = 'bcserver'

$databaseParams = @{
    "databaseServer" = 'host.containerhelper.internal'
    "databaseInstance" = ''
    "databasePrefix" = "$containerName-"
    "databaseName" = 'CRONUS'
    "databaseCredential" = $sqlcred 
    "multitenant" = $false
    "replaceExternalDatabases" = $true
}

New-NavContainer @databaseParams `
    -accept_eula `
    -containerName $containerName `
    -artifactUrl $artifactUrl `
    -Credential $cred `
    -auth UserPassword `
    -publicdnsname 'home.freddy.dk' `
    -licenseFile ($LicenseFileUrlSecret.SecretValue | Get-PlainText)
marioolleshi commented 2 years ago

i am using this script now 

$artifactUrl = Get-BCArtifactUrl -country us -type OnPrem
$cred = New-Object PSCredential -ArgumentList 'admin', -Password 'Adinode1.',
$sqlcred = New-Object PSCredential -ArgumentList 'sa', -Password 'Adinode1,',
$containerName = 'bcserver'

$databaseParams = @{
    "databaseServer" = 'host.containerhelper.internal'
    "databaseInstance" = ''
    "databasePrefix" = "$containerName-"
    "databaseName" = 'CRONUS'
    "databaseCredential" = $sqlcred 
    "multitenant" = $false
    "replaceExternalDatabases" = $true
}

New-NavContainer @databaseParams `
    -accept_eula `
    -containerName $containerName `
    -artifactUrl $artifactUrl `
    -Credential $cred `
    -auth UserPassword `
    -publicdnsname '8.8.8.8'

and it get stuck at Using NavUserPassword Authentication

-- Full erorr below ---


PS C:\Windows\system32> $artifactUrl = Get-BCArtifactUrl -country us -type OnPrem
$cred = New-Object PSCredential -ArgumentList 'admin', -Password 'Adinode1.',
$sqlcred = New-Object PSCredential -ArgumentList 'sa', -Password 'Adinode1,',
$containerName = 'bcserver'

$databaseParams = @{
    "databaseServer" = 'host.containerhelper.internal'
    "databaseInstance" = ''
    "databasePrefix" = "$containerName-"
    "databaseName" = 'CRONUS'
    "databaseCredential" = $sqlcred 
    "multitenant" = $false
    "replaceExternalDatabases" = $true
}

New-NavContainer @databaseParams `
    -accept_eula `
    -containerName $containerName `
    -artifactUrl $artifactUrl `
    -Credential $cred `
    -auth UserPassword `
    -publicdnsname '8.8.8.8' 
New-Object : Cannot bind parameter because parameter 'ArgumentList' is specified more than once. To provide multiple values to parameters that can accept multiple 
values, use the array syntax. For example, "-parameter value1,value2,value3".
At line:3 char:36
+ $sqlcred = New-Object PSCredential -ArgumentList 'sa', -Password 'Adi ...
+                                    ~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-Object], ParameterBindingException
    + FullyQualifiedErrorId : ParameterAlreadyBound,Microsoft.PowerShell.Commands.NewObjectCommand

BcContainerHelper is version 3.0.11
BcContainerHelper is running as administrator
Hyper-V is Enabled
UsePsSession is True
Host is Microsoft Windows 10 Pro - 21H2
Docker Client Version is 20.10.17
Docker Server Version is 20.10.17
Removing Desktop shortcuts
Removing C:\ProgramData\BcContainerHelper\Extensions\bcserver
Starting Database Restore job from https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Fetching all docker images
Fetching all docker volumes
INFO: Windows 10 21H1/21H2 images are not yet available, using 2004 as these are found to work better than 20H2 on 21H1/21H2
Using image mcr.microsoft.com/businesscentral:10.0.19041.1415
PublicDnsName is 8.8.8.8
Creating Container bcserver
Style: onprem
Multitenant: No
Version: 20.5.45456.45889
Platform: 20.0.45448.45882
Generic Tag: 1.0.2.13
Container OS Version: 10.0.19041.1415 (2004)
Host OS Version: 10.0.19044.1889 (21H2)
WARNING: Host OS is 21H1 and Container OS is 2004, defaulting to process isolation. If you experience problems, add -isolation hyperv.
Using process isolation
Using locale en-US
Disabling the standard eventlog dump to container log every 2 seconds (use -dumpEventLog to enable)
Files in C:\ProgramData\BcContainerHelper\Extensions\bcserver\my:
- AdditionalOutput.ps1
- MainLoop.ps1
- SetupDatabase.ps1
- SetupVariables.ps1
- updatecontainerhosts.ps1
Creating container bcserver from image mcr.microsoft.com/businesscentral:10.0.19041.1415
2e7954165ddbcaf9a2e764359ee615860a03ed22477915a4bab73d39a802d124
Waiting for container bcserver to be ready
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 20 seconds
Installation complete
Initializing...
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bcserver
PublicDnsName is 8.8.8.8
WARNING: DNS resolution not working from within the container.
Using NavUserPassword AuthenticationError
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 20 seconds
Installation complete
Initializing...
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bcserver
PublicDnsName is 8.8.8.8
WARNING: DNS resolution not working from within the container.
Using NavUserPassword Authentication
New-NavContainer Telemetry Correlation Id: 43b4a06a-cce8-42cb-9c1f-e19f054fa91f
Initialization of container bcserver failed
At C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\3.0.11\ContainerHandling\Wait-NavContainerReady.ps1:42 char:17
+ ...             throw "Initialization of container $containerName failed" ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Initialization ...bcserver failed:String) [], RuntimeException
    + FullyQualifiedErrorId : Initialization of container bcserver failed
freddydk commented 2 years ago

You have some bad powershell in the beginning and the first error is:

New-Object : Cannot bind parameter because parameter 'ArgumentList' is specified more than once. To provide multiple values to parameters that can accept multiple 
values, use the array syntax. For example, "-parameter value1,value2,value3".
At line:3 char:36
+ $sqlcred = New-Object PSCredential -ArgumentList 'sa', -Password 'Adi ...
+                                    ~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-Object], ParameterBindingException
    + FullyQualifiedErrorId : ParameterAlreadyBound,Microsoft.PowerShell.Commands.NewObjectCommand

The next error is probably due to this one.

Creating credentials in PowerShell looks like:

$cred = New-Object PSCredential -ArgumentList 'admin', (ConvertTo-SecureString -string 'password' -asplaintext -force)

I have never seen the other method.

marioolleshi commented 2 years ago

Now i am using this script and it get stuck in here "Using NavUserPassword Authentication"

$artifactUrl = Get-BCArtifactUrl -country us -type OnPrem
$cred = New-Object PSCredential -ArgumentList 'admin', (ConvertTo-SecureString -string '***' -asplaintext -force)
$sqlcred = New-Object PSCredential -ArgumentList 'admin', (ConvertTo-SecureString -string '***' -asplaintext -force)
$containerName = 'bcserver'

$databaseParams = @{
    "databaseServer" = 'host.containerhelper.internal'
    "databaseInstance" = ''
    "databasePrefix" = "$containerName-"
    "databaseName" = 'CRONUS'
    "databaseCredential" = $sqlcred 
    "multitenant" = $false
    "replaceExternalDatabases" = $true
}

New-NavContainer @databaseParams `
    -accept_eula `
    -containerName $containerName `
    -artifactUrl $artifactUrl `
    -Credential $cred `
    -auth UserPassword `
    -publicdnsname '8.8.8.8'

Full error 

BcContainerHelper is version 3.0.11
BcContainerHelper is running as administrator
Hyper-V is Enabled
UsePsSession is True
Host is Microsoft Windows 10 Pro - 21H2
Docker Client Version is 20.10.17
Docker Server Version is 20.10.17
Removing Desktop shortcuts
Removing C:\ProgramData\BcContainerHelper\Extensions\bcserver
Starting Database Restore job from https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Fetching all docker images
Fetching all docker volumes
INFO: Windows 10 21H1/21H2 images are not yet available, using 2004 as these are found to work better than 20H2 on 21H1/21H2
Using image mcr.microsoft.com/businesscentral:10.0.19041.1415
PublicDnsName is 8.8.8.8
Creating Container bcserver
Style: onprem
Multitenant: No
Version: 20.5.45456.45889
Platform: 20.0.45448.45882
Generic Tag: 1.0.2.13
Container OS Version: 10.0.19041.1415 (2004)
Host OS Version: 10.0.19044.1889 (21H2)
WARNING: Host OS is 21H1 and Container OS is 2004, defaulting to process isolation. If you experience problems, add -isolation hyperv.
Using process isolation
Using locale en-US
Disabling the standard eventlog dump to container log every 2 seconds (use -dumpEventLog to enable)
Files in C:\ProgramData\BcContainerHelper\Extensions\bcserver\my:
- AdditionalOutput.ps1
- MainLoop.ps1
- SetupDatabase.ps1
- SetupVariables.ps1
- updatecontainerhosts.ps1
Creating container bcserver from image mcr.microsoft.com/businesscentral:10.0.19041.1415
e357197a07073b613dff8bba05738553fb4663696ac7b5acb751431396e0560d
Waiting for container bcserver to be ready
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 19 seconds
Installation complete
Initializing...
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bcserver
PublicDnsName is 8.8.8.8
WARNING: DNS resolution not working from within the container.
Using NavUserPassword AuthenticationError
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from C:\Run\150-new
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us
Using installer from 
Installing Business Central
Installing from artifacts
Starting Local SQL Server
Starting Internet Information Server
Copying Service Tier Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files
c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder
Copying PowerShell Scripts
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration
c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch
Copying Web Client Files
c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV
Copying Client Files
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV
c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder
Copying ModernDev Files
c:\dl\onprem\20.5.45456.45889\platform
c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV
Copying additional files
Copying ConfigurationPackages
C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages
Copying Test Assemblies
C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies
Copying Applications
C:\dl\onprem\20.5.45456.45889\us\Applications
Copying dependencies
Copying ReportBuilder
Importing PowerShell Modules
Skipping restore of Cronus database
Modifying Business Central Service Tier Config File for Docker
Creating Business Central Service Tier
Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll'
Installation took 19 seconds
Installation complete
Initializing...
Setting host.containerhelper.internal to 172.19.80.1 in container hosts file
Starting Container
Hostname is bcserver
PublicDnsName is 8.8.8.8
WARNING: DNS resolution not working from within the container.
Using NavUserPassword Authentication
New-NavContainer Telemetry Correlation Id: 38a6fd1e-b647-4fe4-be0e-0d884a3334b1
Initialization of container bcserver failed
At C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\3.0.11\ContainerHandling\Wait-NavContainerReady.ps1:42 char:17
+ ...             throw "Initialization of container $containerName failed" ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Initialization ...bcserver failed:String) [], RuntimeException
    + FullyQualifiedErrorId : Initialization of container bcserver failed
freddydk commented 2 years ago

You should try with hyperv isolation - it looks like you might have an issue with anti-virus or like

marioolleshi commented 2 years ago

same thing happens even if I use hyperv isolation I dont know what i am missing

freddydk commented 2 years ago

Did you check that your SQL Server on the host has a user called admin with the specified password? is SQL Server authentication enabled? is TCP protocol enabled? is firewall open to the SQL Server?

marioolleshi commented 2 years ago

Yes I have all of this in place

freddydk commented 2 years ago

If you remove the @databaseparams parameter - my guess is that it works with no problem?

freddydk commented 2 years ago

does get-bccontainereventlog with the containername reveal anything from the eventlog?

marioolleshi commented 2 years ago

I removed the @databaseParams and now i am getting this error

PS C:\Windows\system32> C:\Users\MarjoLleshi\Desktop\Untitled1.ps1 BcContainerHelper is version 3.0.11 BcContainerHelper is running as administrator Hyper-V is Enabled UsePsSession is True Host is Microsoft Windows 10 Pro - 21H2 Docker Client Version is 20.10.17 Docker Server Version is 20.10.17 Removing Desktop shortcuts Removing C:\ProgramData\BcContainerHelper\Extensions\bcserver Fetching all docker images Fetching all docker volumes INFO: Windows 10 21H1/21H2 images are not yet available, using 2004 as these are found to work better than 20H2 on 21H1/21H2 Using image mcr.microsoft.com/businesscentral:10.0.19041.1415 Creating Container bcserver Style: onprem Multitenant: No Version: 20.5.45456.45889 Platform: 20.0.45448.45882 Generic Tag: 1.0.2.13 Container OS Version: 10.0.19041.1415 (2004) Host OS Version: 10.0.19044.1889 (21H2) WARNING: Host OS is 21H1 and Container OS is 2004, defaulting to process isolation. If you experience problems, add -isolation hyperv. Using process isolation Using locale en-US Disabling the standard eventlog dump to container log every 2 seconds (use -dumpEventLog to enable) Files in C:\ProgramData\BcContainerHelper\Extensions\bcserver\my:

Files: http://bcserver:8080/ALLanguage.vsix

WARNING: You are running a container which is 181 days old. Microsoft recommends that you always run the latest version of our containers.

Container Total Physical Memory is 15.8Gb Container Free Physical Memory is 4.6Gb

Initialization took 113 seconds Ready for connections! Reading CustomSettings.config from bcserver container 2d0600647f64646709757ef2c9abe0097f0807f9ad3689d1f80800810d8e04a6 encountered an error during hcsshim::System::CreateProcess: failure in a Windows system call: T he RPC server is unavailable. (0x6ba) New-BcContainer Telemetry Correlation Id: d6549c80-c881-4550-8924-1af3726fd3fa Error executing script in Container At C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\3.0.11\ContainerHandling\Invoke-ScriptInNavContainer.ps1:269 char:21

freddydk commented 2 years ago

OK - looks like you have something on that box disallowing powershell sessions. you can try hyperv isolation and you can try to use $bccontainerhelperconfig.usePsSession = $false before you create the container.

marioolleshi commented 2 years ago

I ad the $bccontainerhelperconfig.usePsSession = $false and still gives me the same error

this is the srcript i used $artifactUrl = Get-BCArtifactUrl -country us -type OnPrem $cred = Get-Credential -Message 'Using UserPassword authentication. Please enter credentials for the container.' $sqlcred = New-Object PSCredential -ArgumentList 'luki', (ConvertTo-SecureString -string 'Adinode1.' -asplaintext -force) $containerName = 'bcserver' $bccontainerhelperconfig.usePsSession = $false

$databaseParams = @{ "databaseServer" = 'host.containerhelper.internal' "databaseInstance" = '' "databasePrefix" = "$containerName-" "databaseName" = 'CRONUS' "databaseCredential" = $sqlcred "multitenant" = $false "replaceExternalDatabases" = $true }

New-BcContainer -accept_eula -containerName $containerName -artifactUrl $artifactUrl -Credential $cred -auth UserPassword -dns '8.8.8.8' -isolation 'hyperv' -updateHosts

New-BcContainer Telemetry Correlation Id: 6cb4f9a7-75bd-433c-b79e-820f71762fd3 Error executing script in Container At C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\3.0.11\ContainerHandling\Invoke-ScriptInNavContainer.ps1:269 char:21

freddydk commented 2 years ago

Not sure what's wrong with your machine - maybe the antivirus, defender or like. Sorry, but you might be out of luck trying to make bc containers run on that machine.

marioolleshi commented 2 years ago

now it says that container is ready but it has not created any database in SQL Server which i am using

PS C:\Windows\system32> docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS
NAMES 61ee3d9d895b mcr.microsoft.com/businesscentral:10.0.19041.1415 "powershell -Command…" 44 minutes ago Up 44 minutes (healthy) 80/tcp, 443/tcp, 1433/tcp, 7045-7 049/tcp, 7083/tcp, 8080/tcp bcserver

PS C:\Windows\system32> docker logs 61ee3d9d895b Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us Using installer from C:\Run\150-new Installing Business Central Installing from artifacts Starting Local SQL Server Starting Internet Information Server Copying Service Tier Files c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder Copying PowerShell Scripts c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch Copying Web Client Files c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV Copying Client Files c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder Copying ModernDev Files c:\dl\onprem\20.5.45456.45889\platform c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV Copying additional files Copying ConfigurationPackages C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages Copying Test Assemblies C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies Copying Applications C:\dl\onprem\20.5.45456.45889\us\Applications Copying dependencies Copying ReportBuilder Using artifactUrl https://bcartifacts.azureedge.net/onprem/20.5.45456.45889/us Using installer from Installing Business Central Installing from artifacts Starting Local SQL Server Starting Internet Information Server Copying Service Tier Files c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\Program Files c:\dl\onprem\20.5.45456.45889\platform\ServiceTier\System64Folder Copying PowerShell Scripts c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\Cloud\NAVAdministration c:\dl\onprem\20.5.45456.45889\platform\WindowsPowerShellScripts\WebSearch Copying Web Client Files c:\dl\onprem\20.5.45456.45889\platform\WebClient\Microsoft Dynamics NAV Copying Client Files c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\program files\Microsoft Dynamics NAV c:\dl\onprem\20.5.45456.45889\platform\LegacyDlls\systemFolder Copying ModernDev Files c:\dl\onprem\20.5.45456.45889\platform c:\dl\onprem\20.5.45456.45889\platform\ModernDev\program files\Microsoft Dynamics NAV Copying additional files Copying ConfigurationPackages C:\dl\onprem\20.5.45456.45889\us\ConfigurationPackages Copying Test Assemblies C:\dl\onprem\20.5.45456.45889\platform\Test Assemblies Copying Applications C:\dl\onprem\20.5.45456.45889\us\Applications Copying dependencies Copying ReportBuilder Importing PowerShell Modules Restoring CRONUS Demo Database Setting CompatibilityLevel for CRONUS on localhost\SQLEXPRESS Modifying Business Central Service Tier Config File for Docker Creating Business Central Service Tier Installing SIP crypto provider: 'C:\Windows\System32\NavSip.dll' Starting Business Central Service Tier Importing license file Stopping Business Central Service Tier Installation took 127 seconds Installation complete Initializing... Setting host.containerhelper.internal to 172.19.80.1 in container hosts file Starting Container Hostname is bcserver PublicDnsName is bcserver Using NavUserPassword Authentication Creating Self Signed Certificate Self Signed Certificate Thumbprint 744C4693B14A363C0371BE053F39E9FB5A85F6CF DNS identity bcserver Modifying Service Tier Config File with Instance Specific Settings Starting Service Tier Registering event sources Creating DotNetCore Web Server Instance Using application pool name: BC Using default container name: NavWebApplicationContainer Copy files to WWW root C:\inetpub\wwwroot\BC Create the application pool BC Create website: NavWebApplicationContainer without SSL Update configuration: navsettings.json Done Configuring Web Client Creating http download site Setting SA Password and enabling SA Creating Administrator as SQL User and add to sysadmin Creating SUPER user Container IP Address: 172.19.85.118 Container Hostname : bcserver Container Dns Name : bcserver Web Client : http://bcserver/BC/ Dev. Server : http://bcserver Dev. ServerInstance : BC

Files: http://bcserver:8080/ALLanguage.vsix

WARNING: You are running a container which is 181 days old. Microsoft recommends that you always run the latest version of our containers.

Container Total Physical Memory is 15.8Gb Container Free Physical Memory is 4.9Gb

Initialization took 100 seconds Ready for connections!

freddydk commented 2 years ago

Yeah, the thing that fails is invoking scripts in the container. Like Get-BcContainerServerConfiguration fails - and you cannot do much without. You could try to grab the latest containerhelper, but I am not sure it works any better.

On SQL - there is a SQL Server inside the container, which is used. If you add the database parameters - it should restore the database on the host and use that.