web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2016/2017 Developm...
Microsoft Dynamics NAV (Archived)

NAV 2016/2017 Development Environment

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Group Members,

We have a situation, where we are trying to use Azure VM as our NAV Server and SQL Database Server and when we trying to save changes in the Table. We get the following error.

NAV-Compile-ISSUE.png

 

 Please find below further more environment details for your information.

  1. NAV Server and SQL Server is hosted on AZURE VM
  2. NAV Development Environment and client works fine, when connect Azure VM through RDC.
  3. NAV Client can be connected to NAV Service from outside Azure VM with NAVUserPassword credential type
  4. NAV environment is having single database multiple companies in is having single Tenant.
  5. When the Development Environment of NAV 2016 cumulative update 9 or NAV 2017 Cumulative update 1 is opened in Azure VM, we can compile and save tables.
  6. But when we open Development Environment of NAV 2016 cumulative update 9 or NAV 2017 cumulative update 1 in developers Laptop, open a NAV database on Azure VM and try to make changes or add new fields in the tables we get above error.

 

We have already tried following things to resolve the above issue, but the issue is not resolved.

  1. Turned off Windows Firewall on both Azure VM and developer laptop (Windows 10 Enterprise Edition)
  2. Management service is also configured in NAV service and endpoint is also configured on Azure cloud
  3. Configured in development environment in Tools -> Options, entered server port, service name and management port.

But still no outcome, nothing in Event viewer to drill further.

Regards,

M@S

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,


    What about the 5th suggestion in the error message? "Microsoft Dynamics NAV Development Environment is running as administrator". It should do the work ;).

    Besides, double check that the developer is db_owner on the database on SQL

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    Hi ,

    Have you given enough permission to modify you db tables for that users ?  

    Eg :: "GRANT'

  • Community Member Profile Picture
    Community Member on at

    Hi Maneesha,

    Yes, I even tried opening database with SA user Name and started Development environment with "Run as Administrator" option.

    Regards

  • Community Member Profile Picture
    Community Member on at

    Hi Nabil,

    Yes, the security permissions are in place, when you log in Development environment with same credentials it works properly.

    But when you use same credentials, from laptop without RDC. This error is generated.

    Regards,

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    Do you have a partner ??

    i think better to discuss with them

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    [quote user="Anwar Shaikh"]

    But when we open Development Environment of NAV 2016 cumulative update 9 or NAV 2017 cumulative update 1 in developers Laptop, open a NAV database on Azure VM and try to make changes or add new fields in the tables we get above error. 

    [/quote]

    NAV requires a Server instance to compile and save. I think if you'd install the service instance locally on the developer's laptop, and point those setting to the Azure Database it might work.

    When you are connected to the Azure VM the server instance is already there, so it works.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Chad,

    Thanks for the information, it indeed gave me a ray of hope and to think on another direction.

    On Developer environment, instances are created which points, towards their local database. Also those services are configured to use Windows Authentication and the environment which are on VM is configured to use NavUserPassword.

    Will try to configure the service on this weekend and will get back with my findings.

    Regards,

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Dynamics NAV required to connect to service instance when you do any changes to tables. It seems your developer environment cannot find a running NAV instance.

    Check if you can modify any page and save back? I think you will be able to do this without any issue.  Check what is the account used for running the Dynamics NAV Service and check permission.

    Check the account you using to open development environment, verify the account details have required permission to access the NAV service. (Run NAV RTC using the account see how it goes)

  • Community Member Profile Picture
    Community Member on at

    The account that the local service is running on should also have a security login with db_owner on the local database or remote database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans