In SQL Server, between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Posted by Akiii on 5/31/2011 | Category: Sql Server Interview questions | Views: 6268 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Windows Authentication is trusted because the user name and password are checked with the Active Directory, the SQL Server authentication is untrusted , since SQL Server is the only verifier participating in the transaction.

Thanks and Regards
Akiii

Source: techpreparation.com | Asked In: Many Interviews | Alert Moderator