Skip to main content

NAV 2013 R2 - Multi-Tenancy Errors.

Hi all,

During implementation of MultiTenant we have discussed that there are some data common to all companies tables which remain in the application database.

Let's open the application database from SQL Server and see the list.

Now let's open the Windows Client and try to add records in any of these tables.

Yes you end up with an error message saying -

"You do not have permission to insert '' records because the tenant is mounted with the application database as read-only. Contact your system administrator."

Below is the screen shot when i tried to Create a new Chart.

I thought it might be from SQL or NAV. Tried both places but the database was set to read-write mode. Later on i checked the service tier and found the resolution.

Resolution -

1. If you remember in Last Post we discussed about Tenant Configuration file.

2. Let's open the Tenants.config File from the service Instance Folder.

3. Search for Parameter allowAppDatabaseWrite and change the value for all tenant to True as shown below.

4. If you also want NAS to be run on MultiTenant then change the nasServicesEnabled to True as shown below.

5. Restart the Service Instance and we are good to go as shown below.

Saurav Dhyani


  1. Where to change config in case of D365 BC Online???

    1. HI Harsh,
      You are referring to Business Central SASS (D365BC Online). If that is true, then we cannot change config file in business central. You can check with Microsoft to enable it.


Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.