search

microsoft / nav-arm-templates

ARM (Azure Resource Manager) templates for Microsoft Dynamics NAV
MIT License
54 stars 55 forks source link

MultiTenant Deployment with SQLDeveloper Fails #149

Closed ChrisBlankDe closed 3 years ago

ChrisBlankDe commented 4 years ago

I've tested it three times.Always fails for same reason.

ARM Deployment (via aka.ms/getbcext) worked well but it comes to an error wile running container.

4:55:11 PM at , : line 51
4:55:11 PM The tenant 'default' is not mounted or does not exist.
4:42:46 PM Running container (this might take some time)
4:42:46 PM using host as database server
4:42:13 PM Locale de-DE
4:42:13 PM Version 16.3.14085.14328
4:42:13 PM Country de
4:42:13 PM Using artifactUrl https://bcartifacts.azureedge.net/sandbox/16.3.14085.14328/de
4:37:24 PM Installing OpenXML 2.5
4:37:23 PM Installing SQL Native Client
4:37:19 PM Installing Visual C++ Redist
4:37:19 PM Status: Downloaded newer image for mcr.microsoft.com/dynamicsnav:10.0.17763.1339-generic
4:37:19 PM Digest: sha256:a1825dc0693031e86158c4805399d677878739dfe39572f0bea7330b38c34c19
4:37:19 PM fb9edca993e6: Pull complete
4:37:18 PM e5e9144b0b80: Pull complete
4:37:17 PM a742cf654a58: Pull complete
4:37:16 PM a5dc8e2a8759: Pull complete
4:37:15 PM 85f5eb990de2: Pull complete
4:37:06 PM fec714f503c8: Pull complete
4:37:06 PM fff617907868: Pull complete
4:35:35 PM 90125d17086d: Pull complete
4:35:35 PM 4e2b24c036f3: Pull complete
4:35:34 PM daed7e87ad55: Pull complete
4:35:33 PM 4520c21c9ce1: Pull complete
4:35:33 PM 32fad1b53b36: Pull complete
4:34:35 PM 4ce1ae7b9cfc: Pull complete
4:34:35 PM 6dc988e2efd9: Pull complete
4:31:42 PM 8a943217e0a7: Pull complete
4:23:14 PM fff617907868: Download complete
4:23:14 PM fff617907868: Verifying Checksum
4:23:04 PM 85f5eb990de2: Download complete
4:23:04 PM 85f5eb990de2: Verifying Checksum
4:23:04 PM fb9edca993e6: Download complete
4:23:04 PM fb9edca993e6: Verifying Checksum
4:23:04 PM e5e9144b0b80: Download complete
4:23:04 PM e5e9144b0b80: Verifying Checksum
4:23:04 PM a742cf654a58: Download complete
4:23:04 PM a742cf654a58: Verifying Checksum
4:23:04 PM a5dc8e2a8759: Download complete
4:23:04 PM a5dc8e2a8759: Verifying Checksum
4:23:04 PM fec714f503c8: Download complete
4:23:03 PM fec714f503c8: Verifying Checksum
4:23:03 PM 90125d17086d: Download complete
4:23:03 PM 90125d17086d: Verifying Checksum
4:23:03 PM 8a943217e0a7: Download complete
4:23:03 PM 8a943217e0a7: Verifying Checksum
4:23:03 PM 4e2b24c036f3: Download complete
4:23:03 PM 4e2b24c036f3: Verifying Checksum
4:23:03 PM 6dc988e2efd9: Download complete
4:23:03 PM 6dc988e2efd9: Verifying Checksum
4:23:03 PM daed7e87ad55: Download complete
4:23:03 PM daed7e87ad55: Verifying Checksum
4:23:03 PM 4520c21c9ce1: Download complete
4:23:03 PM 4520c21c9ce1: Verifying Checksum
4:23:03 PM 32fad1b53b36: Download complete
4:23:03 PM 32fad1b53b36: Verifying Checksum
4:22:59 PM 4ce1ae7b9cfc: Download complete
4:22:59 PM 4ce1ae7b9cfc: Verifying Checksum
4:22:59 PM fb9edca993e6: Waiting
4:22:59 PM e5e9144b0b80: Waiting
4:22:59 PM a742cf654a58: Waiting
4:22:59 PM a5dc8e2a8759: Waiting
4:22:59 PM 85f5eb990de2: Waiting
4:22:59 PM fec714f503c8: Waiting
4:22:59 PM fff617907868: Waiting
4:22:59 PM 90125d17086d: Waiting
4:22:59 PM 4e2b24c036f3: Waiting
4:22:59 PM daed7e87ad55: Waiting
4:22:59 PM 4520c21c9ce1: Waiting
4:22:59 PM 32fad1b53b36: Waiting
4:22:59 PM fb9edca993e6: Pulling fs layer
4:22:59 PM e5e9144b0b80: Pulling fs layer
4:22:59 PM a742cf654a58: Pulling fs layer
4:22:59 PM a5dc8e2a8759: Pulling fs layer
4:22:59 PM 85f5eb990de2: Pulling fs layer
4:22:59 PM fec714f503c8: Pulling fs layer
4:22:59 PM fff617907868: Pulling fs layer
4:22:59 PM 90125d17086d: Pulling fs layer
4:22:59 PM 4e2b24c036f3: Pulling fs layer
4:22:59 PM daed7e87ad55: Pulling fs layer
4:22:59 PM 4520c21c9ce1: Pulling fs layer
4:22:58 PM 32fad1b53b36: Pulling fs layer
4:22:58 PM 4ce1ae7b9cfc: Pulling fs layer
4:22:58 PM 6dc988e2efd9: Pulling fs layer
4:22:58 PM 8a943217e0a7: Pulling fs layer
4:22:58 PM fc1b9e59edad: Already exists
4:22:58 PM 4612f6d0b889: Already exists
4:22:58 PM 10.0.17763.1339-generic: Pulling from dynamicsnav
4:22:37 PM Pulling mcr.microsoft.com/dynamicsnav:10.0.17763.1339-generic (this might take some time)
4:22:35 PM Adding Landing Page to Startup Group
4:22:35 PM Add Import navcontainerhelper to PowerShell profile
4:22:35 PM Disabling Server Manager Open At Logon
4:22:35 PM Show hidden files and file types
4:22:35 PM Enabling Font Download in IE
4:22:35 PM Enabling File Download in IE
4:22:32 PM Enabling Docker API
4:22:32 PM Starting docker
4:14:06 PM Installing SQL Server Developer edition
4:14:04 PM SetupVm, User: vmadmin
4:13:56 PM Launch SetupVm
4:13:55 PM Register RestartContainers Task to start container delayed
4:13:10 PM Installing SqlServer module
4:12:54 PM Installing AzureAD module
4:09:41 PM Installing Az module
4:09:14 PM Using Lets Encrypt certificate
4:09:05 PM Installing ACME-PS PowerShell Module
4:08:51 PM SetupStart, User: kvstrddemo01$
4:06:27 PM Restarting computer and start Installation tasks
4:06:26 PM Using Nav Container Helper version 0.7.0.20
4:06:09 PM Installing Latest Nav Container Helper from PowerShell Gallery
4:06:08 PM Downloading C:\DEMO\Install-VS2017Community.ps1
4:06:08 PM Downloading c:\demo\restartContainers.ps1
4:06:07 PM Downloading c:\demo\SetupStart.ps1
4:06:06 PM Downloading c:\demo\SetupVm.ps1
4:06:06 PM Downloading c:\demo\SetupAAD.ps1
4:06:06 PM Downloading c:\demo\SetupNavContainer.ps1
4:06:05 PM Downloading c:\demo\SetupDesktop.ps1
4:06:05 PM Downloading c:\myfolder\SetupWebClient.ps1
4:06:05 PM Turning off IE Enhanced Security Configuration
4:06:05 PM Creating Connect.rdp
4:06:05 PM Downloading C:\inetpub\wwwroot\web.config
4:06:04 PM Downloading C:\inetpub\wwwroot\Microsoft.png
4:06:04 PM Downloading C:\inetpub\wwwroot\line.png
4:06:04 PM Downloading C:\inetpub\wwwroot\status.aspx
4:06:03 PM Downloading C:\inetpub\wwwroot\default.aspx
4:02:51 PM Installing Internet Information Server (this might take a few minutes)
4:02:35 PM Installing PowerShellGet 2.2.1
4:02:10 PM TemplateLink: https://raw.githubusercontent.com/Microsoft/nav-arm-templates/master/getbcext.json
4:02:10 PM Initialize, user: kvstrddemo01$
4:02:10 PM Running Windows Server 2019 Datacenter
4:02:10 PM Starting initialization

We used a sandbox artifact (bcartifacts/sandbox/16.3.14085.14328/de/latest), SQLDeveloper and multitenancy. Full Parameterset and Logs: Deployment-Microsoft.Template.zip

freddydk commented 4 years ago

Did you try without multi-tenancy?

ChrisBlankDe commented 4 years ago

Not yet. But running right now.

freddydk commented 4 years ago

I assume that this would work - the multitenant switch to switch the container into multi-tenancy will change the database inside the container, but won't change anything on SQL on the host. Not sure how hard it would be possible to fix the issue.

freddydk commented 3 years ago

This should work now.