11,1 Tạo Windows NT/2000 Người dùng Mặc dù nó có vẻ lẻ để bắt đầu một cuộc thảo luận về an ninh SQL Server bằng cách mô tả quá trình thêm người sử dụng Windows NT/2000, điều quan trọng cần lưu ý là SQL Server bảo mật được tích hợp chặt chẽ với cơ quan đăng ký bảo mật Windows | Create Windows NT 2000 Users Although it might seem odd to begin a discussion of SQL Server security by describing the process of adding users to Windows NT 2000 it s important to note that SQL Server security is tightly integrated with the Windows security registry. SQL Server administrators are pleased with the fact that SQL Server automatically recognizes Windows NT and Windows 2000 users saving a considerable amount of administrative time. This section explains the process of adding new users to Windows 2000. The next section describes how to add functional groups to Windows. Although these sections deal with Windows 2000 the process is nearly identical for Windows NT. Windows must recognize users before they can log in to the network and use the computer s resources. You need to add a number of users to the Windows user registry. How do you make sure that all users are required to provide a network password before they can access the network Technique Windows users cannot be added to the system from within SQL Server s Enterprise Manager. You ll have to use the Windows Control Panel applets to add new users and groups. Note The settings you choose on this page of the Add New User dialog box do not affect the SQL Server settings you establish for the user. The settings you see in Figure relate only to Windows and not SQL Server or the database data. Figure . Most of your users will be set up as Standard Users with no special capabilities. Note The first step in the following example is different on Windows NT and Windows 2000. For Windows NT you go to Start Programs Administrative Tools User Manager. For Windows 2000 you go to Start Settings Control Panel Administrative Tools Computer Management then you right-click on Users. Also you must have administrative rights on the computer to add users to it. Steps SQL Server security is tightly integrated with Windows NT 2000 security. SQL Server recognizes the users and groups that are added to
