Answer:
Sql server have 2 different authentication
1) Windows Authentication
2) SQL Authentication
Windows authentication uses the windows credentials to authenticate the user and takes it to the server
SQL authentication uses sql user name and password to authenticate the user and its secure as well
Microsoft suggests to use windows authentication inorder to maintain a single authentication by maintaining in active directory
Asked In: Many Interviews |
Alert Moderator