How to add windows login on sql server

maya-chan
maya-chan Member Posts: 45
edited 2012-08-09 in NAV Three Tier
Hai masters,

I have a trouble on Nav 2009 w/ Sql Server. I want loging by windows authentication, but when i choose windows authentication then ok, it's shown message "The user id and password are invalid. Try again".

What step I must to do to complete and pass it?

Please

Thx

Comments

  • ara3n
    ara3n Member Posts: 9,258
    login into nav using db authentication. Click tools->security->windows authentication. Add all the users. Assign roles the users. And then relogin using windows authentication.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • navuser1
    navuser1 Member Posts: 1,334
    ara3n wrote:
    login into nav using db authentication. Click tools->security->windows authentication. Add all the users. Assign roles the users. And then relogin using windows authentication.

    Without Synchronization will these work ? :-k
    Now or Never
  • Sog
    Sog Member Posts: 1,023
    No, without syncronising (aka notifying the SQL server of the users and rights) it will not work.
    I guess ara3n didn't feel the need to spell out every step.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • ara3n
    ara3n Member Posts: 9,258
    If you are using Standard Security Model, which I recommend, you don't need to synchronize. The moment you add the user, nav will add it to sql.

    If you are using enhanced, I suggest to change it to standard.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Sog
    Sog Member Posts: 1,023
    ara3n, I have always had a multitude of problems when not synchronising users (like earlier today for a 5.0 client).
    All the NAV installations we service have the standard security model.
    Is this something new since NAV09/SQL2008(R2) or is it America only or am I doing something wrong?
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • ara3n
    ara3n Member Posts: 9,258
    If you are adding new tables, then you would need to sync. Or if you are backing/restoring sql server. Otherwise there is no need to sync.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • search1110
    search1110 Member, No Posting Permissions Posts: 19
    Ara3n: Why you are playing dumb all the times? Tell us. The question was there is no db users in it. The man pumped the data including windows logins, SQl mapping has all the users to allow them to connect the database. and yet he cannot start NAV and told "...Password is invalid...". And you still playing dumb and giving stupid advices. Stop it! if you do not know just ignore the question as it is not for you. Crap.

Categories