any help reguarding this issue-experts

mdsrmdsr Posts: 151Member
edited 2019-08-20 in NAV Three Tier


  • suraj92291suraj92291 Posts: 49Member
    which issue..cant see anythng
    “Any fool can know. The point is to understand.”
    ― Albert Einstein
  • MKhan2019MKhan2019 Posts: 5Member
    Hi Suraj,

    I am relatively new to Microsoft Navision 2009. My Company still uses it and wants me to customize it. I have read online that Microsoft Dynamics NAV 2009 Classic with SQL server is the right tool to do that and i am able to connect the database to this software as well. Now upon successful login yesterday, i have tried to create a new user in navision for myself. Already done that in SQL server mgmt studio and need to do that here. So went to database login and tried to create User. it was not accepting any of the users which were there in the SQL security login directory.

    So i tried using SA which is general and sort of super account. However, I don't want to implement any roles for this SA. I tried exiting the window and now this user SA is able to login using this software but unable to see any thing as its permissions are changed which it was seeing earlier. Can anyone help me on how to get its permissions back in Microsoft Dynamics NAV 2009 R2 with SQL server. I meant to see and edit things in this software.

    I am really stuck on this point. Really appreciate help from anybody.


  • lubostlubost Posts: 557Member
    1. Do not use sa as NAV user
    2. Depending on domain present create domain/database user via SSMS with db_owner permission
    3. Using existing user append this user to NAV users (domain/database) with SUPER role
    4. All done and new user should login into development environment

    Do not customize anything if you don't know dependencies in NAV.
Sign In or Register to comment.