11,6 Tạo một Windows NT/2000 Đăng nhập Bất kỳ người dùng là truy cập vào SQL Server từ một Windows NT hoặc Windows 2000 máy tính (nhưng không phải Windows 98 hay ME) có thể được ban cho một SQL Server đăng nhập Windows NT/2000. | Create a Windows NT 2000 Login Any user who is accessing SQL Server from a Windows NT or Windows 2000 computer but not Windows 98 or ME can be given a SQL Server Windows NT 2000 login. Although setting up the NT 2000 login is almost the same process as creating a standard login you have the option of adding the user as any of the following An individual user A member of an NT 2000 group A member of the SQL Server built-in group I want to take advantage of the fact that the users on my system have all been assigned to functional groups such as marketing and sales in Windows NT or Windows 2000. Because these groups parallel the user s SQL Server activity I d like to use each person s network identity as his SQL Server login. Using a person s Windows NT 2000 group saves a lot of administrative time. Rather than creating a custom login for each user I can assign a login to a Windows NT 2000 group and SQL Server can recognize any individual as valid who belongs to the group. Technique You first create a Windows 2000 user or group and then create a SQL Server login for that user or group. Earlier in this chapter you read how to add users and groups to Windows NT 2000. You ll now use the Windows Enterprise Manager dialog boxes to establish SQL Server logins for those users and groups. Steps If the user is working with Windows NT or 2000 you are able to establish a Windows NT 2000 login identity for him. As you ll see using a Windows NT 2000 login is less work than using standard logins. When a user logs in to a SQL Server or Windows NT 2000 account his identity is verified against the account information that Windows manages. SQL Server security is tightly integrated with Windows login information and SQL Server knows and understands the user s identity. SQL Server recognizes the user s personal identity as well as his Windows group membership. Even if no personal SQL Server login is established for the user as long as a SQL Server login is established for at least .
