Authenticating Logins - Tracing Login Network Traffic
(Page 12 of 24 )
Figure 2-5 shows the configuration of the network I set up for this section.
Figure 2-5. The test network for SQL Server 7.0 and 2000
As in the test network for SQL Server 6.5, each of the machines shown is a virtual machine running on VMware’s GSX Server product (http://www.vmware.com) on a private, closed network. The primary difference between the configuration for SQL Server 6.5 and the configuration in Figure 2-5 is the use of SQL Server 7.0 and SQL Server 2000 on the same network. Although both start out the test running on Windows NT, it turned out that Windows 2000 did not change the authentication process at all. Here is a description of each server’s role in the testing environment:
- NT4DC is a Windows NT 4.0 Service Pack 6 domain controller for the NTTEST domain.
- W2KDNS is a Windows 2000 Service Pack 2 member server running WINS, DNS, and DHCP. It is not a member of the domain.
- SS7_NT_SRV is a Windows NT 4.0 Service Pack 6 member server running SQL Server 7.0 with Service Pack 4. It is a member of the NTTEST domain.
- SS2K_NT_SRV is a Windows NT 4.0 Service Pack 6 member server running SQL Server 2000 with Service Pack 2. It is a member of the NTTEST domain.
- W2KCLIENT is a Windows 2000 Professional Service Pack 2 client computer with the SQL Server 7.0 Service Pack 4 client tools installed. It is a member of the NTTEST domain. (Note that none of the following explanations would change if the client were running Windows NT Workstation, or even Windows 9 x, instead of Windows 2000 Professional.)
- MONITOR runs Windows 2000 Professional Service Pack 2 and acts as the monitoring station where NetMon runs. It is not a member of the NTTEST domain, and it has been specially configured to produce very little network traffic.
The operating system versions and service packs are the same as the test network in the previous section.
 This is from SQL Server Security Distilled, second edition, by Morris Lewis (Apress, ISBN 1590592190). Check it out at your favorite bookstore today. Buy this book now. |
Next: The Super Socket Network Library >>
More MS SQL Server Articles
More By Apress Publishing
/ 18 
