What is the difference between windows authentication and sql server authentication

Questions by heena_27

Showing Answers 1 - 6 of 6 Answers

sidver

  • Jul 16th, 2008
 

Windows authentication will uses the credentials of the currently logged user to login in to the sql server database. Your application need not to supply the user name and password.
for SQL server authentication we have to supply the sql database user name and password. That will be used to get the privileges and rights of the user.


srialekhya

  • Apr 22nd, 2009
 

Windows authentication is highly secure than SQL Server authentication why because we need not provide any login details. So the chance of tracing login details from code by the unauthorized persons will be less. Windows authentication uses the default windows login credentials.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions