11,5 Tạo một Đăng nhập Standard Các phần thảo luận trước đó xác thực, mà là không có gì hơn quá trình làm thế nào nhận ra người sử dụng SQL Server | Create a Standard Login The previous sections discussed authentication which is nothing more than the process of how SQL Server recognizes users. Authentication is much like the method used to allow people to get through the front door of an office building. The building may use a simple key card lock or the company may use a guard to check IDs as people enter the building. In either case the person s identity is verified before entry is granted. Earlier in this chapter you read about the Windows NT 2000 authentication process. When using Windows NT 2000 authentication a trusted connection is established between SQL Server and the user s computer. However trusted connections cannot be established between SQL Server and Windows 95 or 98 machines or Apple Macintoshes Unix or other non-Windows computers. After you determine which type of SQL Server authentication to use you must establish a login for each of your users. A login is how the user gains access to SQL Server after the authentication process. A login is how SQL Server establishes your identity within SQL Server and how SQL Server determines your permissions to use data and database objects. You can choose from two different types of logins Standard SQL Server login Windows NT 2000 login When no trusted connection exists between the user s computer in SQL Server SQL Server has no way of obtaining the user s identity from the operating system. Therefore mixed mode application must be used to validate the user and a standard SQL Server login must be created so that SQL Server recognizes the user. The login you establish only provides access to SQL Server it does not provide access to databases data or database objects. Not every SQL Server user will be working with Windows NT and Windows 2000. Some users might be connected to the network from a Unix or Macintosh machine. These users will not be able to use a Windows NT 2000 login and you have to establish a standard SQL Server login for them. This is also
