8.24.2012

Difference between Windows Authentication and SQL Server Authentication in SQL Server

Difference between Windows Authentication and SQL Server Authentication in SQL Server
S.No
Windows Authentication
SQL Server Authentication
1
Windows Authentication is trusted because the user name and password are checked with the Active Directory
SQL Server authentication is untrusted , since SQL Server is the only verifier participating in the transaction
2
Single User can only login
Multi user can login

No comments:

Post a Comment