any help reguarding this issue-experts

mdsr

.

suraj92291

which issue..cant see anythng

MKhan2019

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.

Thanks

Khan

lubost

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.