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) / Adding SQL Login users...
Microsoft Dynamics NAV (Archived)

Adding SQL Login users in NAV DB

(0) ShareShare
ReportReport
Posted on by Sulav Thapaliya 12

Hello All,

I have created a new user in my SQL Server 2014.I was trying to add that user in my NAV DB,but I could not find that user in list when trying to add from the user card.How can I add that user in my NAV DB?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    Check this link

    community.dynamics.com/.../nav-classic-amp-rtc-how-to-add-users-in-database

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Please check this

    www.dynamics101.com/how-to-createsetup-new-users-in-nav-2013

    when you search for the user try to search in the whole domain, select proper location in the select user or group window, which is no. 4 step in the above blog.

  • Community Member Profile Picture
    Community Member on at

    Hi Sulav,

    As I see, you accepted the two previous answers. But I'd like to add a little precision. You do not need the "I have created a new user in my SQL Server 2014" part. NAV handles this for you automatically depending on NAV version.

    Follow the steps below to check what I'm saying:

    1. in your test environment, create a user DOMAIN\NAVUSER1 (windows user)
    2. add this user to your NAV 2015 (do not do anything on SQL)
    3. set permission for the user (SUPER for example)
    4. Check your SQL

    Result: You will not see DOMAIN\NAVUSER1 anywhere in SQL (server level or database level).

    P.S: what I described, is not applicable if you want your user to access the development environment. In this specific case, you should add it to SQL and set necessary permission on the database. db owner works fine for me, although I think it is not the strict minimum.

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