---- SQL Server 2000是为创建可伸缩电子商务、在线商务和数据仓储解决方案而设计的真正意义上的关系型数据库管理与分析系统。
---- Microsoft SQL Server 2000针对包括集成数据挖掘、OLAP服务、安全性服务及通过Internet对多维数据集进行访问和链接等在内的分析服务提供了新的数据仓储功能。
----除了提供电子商务所需的可伸缩性与可扩展性之外，SQL Server 2000还提供了丰富的基于Web标准数据库编程功能，以确保系统的协同工作和灵活性。与此相关，SQL Server 2000还包括丰富的XML、W3C标准支持。具有通过Transact SQL实现的XML数据操作能力、灵活而强大的Web分析功能以及使用HTTP进行的安全Web数据访问功能。
ISA、SQL Server的安装
Microsoft Internet Security & Acceleration Server 2000
1.安装时，请注意确保计算机满足Microsoft Internet Security & Acceleration Server 2000的系统要求。有关更多信息，请参见Microsoft Internet Security & Acceleration Server 2000的硬件和软件安装要求。
2.安装网卡、调制解调器（或是ISDN等）连接内部局域网和外部互联网。
3.设置TCP/IP，设置内部外部IP地址。详情参见技术手册。
4.运行安装盘上的ISA Server Enterprise Initialization，对参数进行设置。
lArray policy only. Select Use array policy only if each array should have its own policy, which can be administered by the array administrator.
lEnterprise policy only. Select Use this enterprise policy and type the name of the enterprise policy. In this case, the same enterprise policy will be applied to all the arrays in the enterprise. Unique access policies cannot be defined for each array in the enterprise. No rules can be defined at the array level.
lCombined enterprise and array policy. Select Use this enterprise policy and Allow array-level access rules to restrict enterprise policy. In this case, array administrators can define rules that further restrict the enterprise policy. For example, if the enterprise policy allows access to all sites, array administrators could refine that policy, by creating rules denying access to specific sites.
lIf array administrators are allowed to publish internal servers, making those servers accessible to external (Internet) clients, then select Allow publishing rules to be created on the array.
lSelect Use packet filtering on the array if packet filtering should always be enabled for the arrays in the enterprise. If you select this option, then the array administrator will not be able to disable packet filtering.
When ISA Server Enterprise Initialization is finished, the ISA Server schema is installed to Active Directory. You can now install ISA Server as an array member, creating the array that the ISA Server should join.
Note
The array creation process takes place when you install ISA Server on the first computer in the array. The information that is added to the Active Directory may take some time to replicate to all domain controllers. Therefore, if you receive an error message during installation that the ISA Server schema has not been installed, even though you have installed it, you must wait until the schema change has been replicated to the local domain controller.
Important
You must install the Windows 2000 Service Pack 1 or later before you install ISA Server.
If the computer on which you are installing ISA Server is not part of a Windows 2000 domain, then ISA Server will be installed as a stand-alone server. You can subsequently add the server to a Windows 2000 domain, and then join it to an array.
The first server in the new array defines a new array in Active Directory. You should allow sufficient time for the array information to replicate throughout the site before you add more members to the array.
When you install an ISA Server computer as a member of an existing array, you must install it in the same mode as the other array members. For example, if all the servers in the array were installed in firewall mode, then the new ISA Server computer must also be installed in firewall mode. The new ISA Server computer adopts the array's enterprise settings, access policy, publishing policy, and monitoring configuration.
You can select the disk drives that are available for caching during ISA Server installation. By default, the setup process searches for the largest NTFS partition and sets a default cache size of 100 megabytes (MB) if there are at least 150 MB available. When configuring the cache drives, you must, at a minimum, allocate at least one NTFS drive, setting aside at least 5 MB on that drive for caching. However, it is recommended that you allocate at least 100 MB and add 0.5 MB for each client that uses the HTTP or FTP protocols, rounded up to the nearest full megabyte.
The local address table (LAT) is a table of all IP address ranges used by the internal network behind the ISA Server computer. ISA Server uses the LAT to control how machines on the internal network communicate with external networks and decides which network adapters should be protected by loading the packet filter driver.
ISA Server can construct the LAT for you by basing it on your Windows 2000 routing table. You can also select the private IP address ranges, as defined by the Internet Assigned Numbers Authority (IANA) in RFC 1918. These three blocks of addresses are reserved for private intranets and are never used on the public Internet.
When creating a LAT, you should only include addresses on the private network. This means that you should not add the external interface of the ISA Server computer, any Internet sites, or any other external addresses including the DNS server at your Internet service provider, and so forth. An incorrect configuration of the LAT could make your network vulnerable to attacks.
The LAT is managed centrally, because it is maintained on the ISA Server computer. Firewall clients automatically download and receive LAT updates at preset, regular intervals.
Microsoft SQL Server 2000 （详细情况参见白皮书）
1.安装时，请注意确保计算机满足 Microsoft SQL Server 2000 的系统要求。有关更多信息，请参见 SQL Server 2000 的硬件和软件安装要求。
2.在运行 Microsoft Windows NT 或 Micorsoft Windows 2000 的计算机上安装 SQL Server 2000，并且希望 SQL Server 2000 与其它客户端和服务器通讯，则创建一个或多个域用户帐户。有关更多信息，请参见创建安全帐户
3.用具有本地管理权限的用户帐户登录到操作系统，或者给域用户帐户指派适当的权限。
4.关闭所有和 SQL Server 相关的服务。包括所有使用 ODBC 的服务，如 Microsoft Internet Information 服务 (IIS)。
5.关闭 Microsoft Windows NT 事件查看器和注册表查看器（Regedit.exe 或 Regedt32.exe）。
ISA、SQL SERVER的配置
1.配置SQL Server TCP/IP网络协议
使用SQL Server Network Utility工具进行配置，启用TCP/IP协议，添加WinSocket代理，设置代理服务器的IP[末页]
