tailieunhanh - Establish a Windows NT/2000 Authentication Mode

11,3 Thiết lập một Windows NT/2000 Authentication Mode SQL Server là một công cụ cơ sở dữ liệu phức tạp hơn so các hệ thống máy tính để bàn như Jet. SQL Server là một động cơ máy chủ thực sự, nó cung cấp quyền truy cập vào cơ sở dữ liệu nhiều hoặc thậm chí hàng trăm người sử dụng đồng thời. | Establish a Windows NT 2000 Authentication Mode SQL Server is a much more complex database engine than desktop systems such as Jet. SQL Server is a true server engine it provides access to multiple databases or even hundreds of users simultaneously. Furthermore unlike Jet which is tightly bound into Microsoft Access SQL Server exists as a separate entity on a computer which most often is located across a network from the user s desktop computer. A building that contains multiple offices is a good analogy for the way that SQL Server is built. The building is secured and each office within the building is locked. Carrying the analogy further each office contains locked desk drawers and filing cabinets. A person who wants to use information in one of those file cabinets must enter the building gain entrance to a locked office and have a key or other permission to open a locked file cabinet. SQL Server requires each user to be authenticated before it permits the user to open a database. Authentication is somewhat like having to show an employee ID card to a guard at the front door of a building. Without proper credentials you don t get into the building. Similarly you don t get into SQL Server unless you have been properly authenticated. SQL Server supports two different authentication modes Windows NT 2000 authentication. This mode means that SQL Server explicitly trusts Windows to authenticate the user. Anyone who has a valid Windows user ID and password is allowed to access SQL Server. This is known as a trusted connection because SQL Server trusts Windows to allow only qualified people into the computer system and onto SQL Server. Windows NT 2000 Authentication works only with Windows NT or Windows 2000 and it has the distinct advantage of being quite simple to administer. Furthermore the Windows NT 2000 security provides for expiration and other controls over password usage. In fact SQL Server even recognizes the user s membership in Windows security groups.