What are the different authentications in sql server

 Posted by Karthikanbarasan on 2/3/2011 | Category: Sql Server Interview questions | Views: 2861 | Points: 40

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 

Comments or Responses

Login to post response