What is the exact difference between Windows-Database login

Kau_147

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.....

vijay_g

Are you technical or functional(doesn't matter)..?

Anyway did you google it? You can find better by search.

mohana_cse06

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

ara3n

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.

mohana_cse06

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?

ara3n

no still windows authentication, but you can specify the users.

mohana_cse06

I know it is avaialbe in 2009R2..is it avaialbe in 2009SP1 also?

ara3n

my typo, it's in R2.

Kau_147

Dear mohana_cse06 & ara3n

Thanks alot