Small and medium business | Business Central, N...

Two VM with Dynamics 365 BC Instance on each one

(0) Share

Report

Posted on by Mohammed Marhoon

207

We created two VM on Azure first once connected to Azure SQL Database using Encrypted Connection and working fine with two databased Application Database and Company Database.

Now Second VM we installed everything but we are not able to connect we used export import key for the encrypted connection but still we are not able to connect.

All responses (6)

Answers (0)

raelhefn on at

Like (0)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Mohamed,

Good News.

Thank you.
Mohammed Marhoon 207 on at

Like (1)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Raelhefn,

We solve the issue thank you so much for your effort.

What I did to solve the issue:

1) Clear the DatabaseName setting in the Business Central Server instance configuration file

Set-NAVServerConfiguration –ServerInstance BC170 –element appSettings –KeyName 'DatabaseName' –KeyValue ''

2) Start the Business Central Server instance

Start-NAVServerInstance –ServerInstance BC170

3) Copy the Key from the Instance Working, and Past it in the Instance not working

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\170\Server\Keys\

4) Mount the application database on the Business Central Server instance

Mount-NAVApplication –ServerInstance BC170 –DatabaseServer XXXXXXXX.database.windows.net –DatabaseName 'XXXXXX' -DatabaseCredentials (Get-Credential)

5) Restart the Business Central Server instance
Mohammed Marhoon 207 on at

Like (0)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Raelhefn,

Appreciate your all valuable information you do share, as i explain we know all this configuration.

Our issue we exported the key from the VM1 which its working, and import it on VM2 which the BC running. however on VM1

stopped due getting the following error:

The NAV application could not be mounted for database 'Business Central App (17-0)' on database server XXXXXX.DATABASE.WINDOWS.NET' due to the following error: The Microsoft Dynamics 365 Business Central Server instance cannot connect to the application database because it is using a different password encryption key than the one currently used on the database.

vise versa if we re-do it on VM1 its working, but on VM2 stopped
Suggested answer

raelhefn on at

Like (0)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Mohamed,

refer to this blog post for how to set up an encryption key and configure SQL Authentication on the database.

chrisdsilvablog.wordpress.com/.../

For more detail information please refer to :

docs.microsoft.com/.../managing-encryption-keys-for-sql-server-authentication

docs.microsoft.com/.../configuring-microsoft-dynamics-nav-server

docs.microsoft.com/.../troubleshoot-common-errors-issues

docs.microsoft.com/.../configure-sql-server-authentication
Mohammed Marhoon 207 on at

Like (0)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Raelhefn,

Appreciate your time, and information shared with me.

our BC up and running on the first VM, and accessible from public, the only issue the second VM we are creating for load balancing BC already installed, but we can not connect to Azure SQL Database due to the encrypted connection key not matching even we export it from first VM and import it on second VM.
Suggested answer

raelhefn on at

Like (0)

Report

RE: Two VM with Dynamics 365 BC Instance on each one

Hi Mohamed,

Please take a look into the following:

demiliani.com/.../

community.dynamics.com/.../how-to-access-d365bc-instance-server-in-azure-form-my-local-pc

docs.microsoft.com/.../deploying-microsoft-dynamics-nav-on-two-virtual-machines-using-example-2vm-script

docs.microsoft.com/.../walkthrough--deploying-microsoft-dynamics-nav-on-two-microsoft-azure-virtual-machines

In your case it may be related to firewall configuration

docs.microsoft.com/.../tutorial-hybrid-portal