Installing and configuring NAV 2016 multitenant in SQL Azure.

(0) Share

Report

Posted on by Community Member

Hi all,

We already install and configure NAV 2016 multitenant on Azure VM and On premises enviroment using SQL Server , but now we need using SQL Azure ,we following the same steps but appears errors that we not have in the previous installations ( using SQL Server) .

Are there specific videos or training materials about installing Nav 2016 multitenant enviroment using SQL Azure?

Can somebody help us?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

aavio 895 on at

Like (0)

Report

please check this link "How Do I: Setup Microsoft Dynamics NAV to Work with Azure SQL"

www.youtube.com/watch

just curious to know, why prefer to use azure sql instead of sql on azure vm.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks aavio for your response and help!!.

We watch already this video but the video does not talk about multitenant installation.

The main reason is to reduce the cost of implementation, for us this is the first

implementation of this type.

Thanks.

Was this reply helpful? Yes No
Suggested answer

aavio 895 on at

Like (0)

Report

i havent worked with SQL azure but, I think we can combine steps for setting up multi tenancy and steps in video it should work. basically with multitenancy, we will have separate databases for object(application database) and tenants data.

Multitenancy Setup steps -->

http://www.ecanarys.com/blog-entry/microsoft-dynamics-nav-2013-r2-multitenancy-deployment

may be you can try the below steps

first prepare databases for multitenancy within VM SQL server and export to Azure SQL server

1- backup the existing database and restore a new database in the VM sql server.

2- split Application database and customer data(using powershell Export-NAVApplication)

After this step you will have two databases in your VM SQL server

3- Export both databases to Azure SQL.(follow the instructions in above mentioned video)

4-Configuring Middle tier (follow the steps as in link and provide databaseserver as azure instance name)

a-stop service

b-enable multitenancy & set the database name key value as blank

c-start service

d-Mount-NAVApplication database

e-Mount-NAVTenant database

Was this reply helpful? Yes No
Suggested answer

aavio 895 on at

Like (0)

Report

check this link also, totovic.com/.../nav-on-azure-sql-on-navtechdays

multi tenancy setup on azure sql powershell script is available to download in the blog.

please check the video and new posts in the same blog.

Was this reply helpful? Yes No
Nicolai Mikael Hansen 24 on at

Like (0)

Report

In case you haven't found an answer yet, I have made a blogpost and a powershell script that might be useful to you. primarilynav.wordpress.com/.../automating-moving-nav-to-azure-sql-and-multitenancy

Was this reply helpful? Yes No