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.



Regards,
Saurav Dhyani
Labels:
Location: Sector 12, Noida, Uttar Pradesh, India

Comments

  1. HarshSeptember 30, 2019 at 4:13 PM

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

    ReplyDelete
    Replies
    1. Saurav DhyaniSeptember 30, 2019 at 4:55 PM

      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.

      Delete

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    ---------------------------
10 comments
Read Complete Article »

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searching for the error i figured out the issue was due to - Design change in NA
4 comments
Read Complete Article »

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.
Post a Comment
Read Complete Article »