Thursday, October 25, 2012

Difference between Windows and Sql Server authentication

  • SQL server authentication requires credentials,useful where multiple users can access to different databases on shared server.
  • Windows authentication-Useful when accessing from same computer and does not require credentials since it already knows that someone is logged in into the OS with the correct credentials

No comments:

Post a Comment