Authentication
Authentication involves ensuring that a user is who he says he is. After SQL Server authenticates a user, the user can perform any actions specifically granted to his login, as well as actions granted to any roles that the user is a member of.
Types of Authentication
Two types of authentication exist:
SQL Server and Windows (mixed authentication)
Windows Only
With SQL Server and Windows authentication, SQL Server supports both SQL Server and Windows NT/Windows 2000 logins. With Windows Only authentication, SQL Server supports only Windows NT/Windows 2000 logins. When you install SQL Server, you can configure the type of authentication that SQL Server will use. To modify the type of authentication that you want to use:
1. | Launch ... |
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
