Options

What is the exact difference between Windows-Database login

Kau_147Kau_147 Member Posts: 84
edited 2012-04-02 in Navision Attain
Dear All,

1) What is exact difference between Windows Login & Database Login in Navision?
2) Why we required only Windows login in RTC?

Thanks in advance..... :)
Best Regards,
Kavita Mutha

Comments

  • Options
    vijay_gvijay_g Member Posts: 884
    Are you technical or functional(doesn't matter)..?

    Anyway did you google it? You can find better by search.
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    With Windows authentication, when a user tries to connect to a server and open a database, he does not have to supply a user ID or password. Microsoft Dynamics NAV automatically determines whether a user, who has already logged on to the network, has a valid Windows account and access is granted to a particular server.

    Users are given a database login when they have their own user ID and password in Microsoft Dynamics NAV. The user must enter the user ID and password to access the database.Using the SQL Server Option, users must also have a login on SQL Server. SQL Server has its own authentication of the user’s ID and password. SQL Server does this by checking whether a SQL Server login with this user’s ID and password has been created.

    http://www.mibuso.com/forum/viewtopic.php?f=23&t=9438
  • Options
    ara3nara3n Member Posts: 9,256
    With Windows authentication, when a user tries to connect to a server and open a database, he does not have to supply a user ID or password. Microsoft Dynamics NAV automatically determines whether a user, who has already logged on to the network, has a valid Windows account and access is granted to a particular server.

    In 2009 SP1, there is a setting in clientsettings.xml that allows the RTC to open a dialog window for the user to type login and password.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    ara3n wrote:
    With Windows authentication, when a user tries to connect to a server and open a database, he does not have to supply a user ID or password. Microsoft Dynamics NAV automatically determines whether a user, who has already logged on to the network, has a valid Windows account and access is granted to a particular server.

    In 2009 SP1, there is a setting in clientsettings.xml that allows the RTC to open a dialog window for the user to type login and password.

    Are they Database Authentications?
  • Options
    ara3nara3n Member Posts: 9,256
    no still windows authentication, but you can specify the users.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    I know it is avaialbe in 2009R2..is it avaialbe in 2009SP1 also?
  • Options
    ara3nara3n Member Posts: 9,256
    my typo, it's in R2.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    Kau_147Kau_147 Member Posts: 84
    Dear mohana_cse06 & ara3n

    Thanks alot :)
    Best Regards,
    Kavita Mutha
Sign In or Register to comment.