Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Thiết lập 11,4 Mixed-Mode Authentication Các thay thế cho chứng thực Windows NT/2000 là hỗn hợp chế độ xác thực. Trong sự sắp xếp này, người dùng được chứng thực đầu tiên của Windows, và một lần nữa chứng thực của SQL Server như ông cố gắng để truy cập cơ sở dữ liệu. | 11.4 Establish Mixed-Mode Authentication The alternative to Windows NT 2000 authentication is mixed-mode authentication. In this arrangement a user is first authenticated by Windows and is again authenticated by SQL Server as he tries to access a database. Mixed-mode is the only authentication for users who are working on Windows 98 computers or Macintoshes Unix and other nonWindows machines. My network includes a number of non-Windows computers such as Apple Macintoshes. In addition several users are working from Windows 98 computers. I discovered that these users are unable to access the SQL Server databases that I created. It appears that mixed-mode authentication might be the only way for these users to access SQL Server. Technique Again Enterprise Manager provides the dialog boxes that are necessary to set mixedmode authentication. After mixed-mode is set users must first log in to Windows or at least access the SQL Server machine from a Windows network and then provide a username and password to SQL Server before using a database. Steps In mixed-mode authentication the user first logs into Microsoft Windows and then into SQL Server. At each step the user s credentials are authenticated. Mixed-mode authentication means that SQL Server keeps a record of users who are allowed to log in to SQL Server. It matches their password with the password that is stored with their user record. SQL Server stores the user s login information in a system table named syslogins in the master database. This table includes an encrypted security ID SID and the user s encrypted password. The other information that is stored in the syslogins table is discussed in the next two sections. 1. Use Start Programs Microsoft SQL Server Enterprise Manager to open Enterprise Manager. 2. Open the SQL Server group and right-click on the server you want to configure. 3. Select Properties from the context menu that appears. The Properties command should be highlighted in the context menu. 4. .
