OT: SQL2000 SP2
- From: "John Tolmachoff" <isalist@xxxxxxxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Tue, 18 Jun 2002 11:53:25 -0700
Any one running SBS may want to make note of this:
* SQL Server 2000 SP2 CAUSES NAT PROBLEMS ON RRAS SERVER
If you support a Microsoft SQL Server that also runs RRAS with Network
Address Translation (NAT) or Internet Connection Sharing (ICS), be advised
that SQL Server 2000 Service Pack 2 (SP2) sets a registry value that
severely restricts the addresses the RRAS NAT driver allocates to outgoing
connections. The SP2 installation script limits the TCP/IP port range to
only two addresses--1433 and 1434--in the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\Reserv
edPorts
registry subkey. The Windows 2000 NAT driver reads this key and limits
outgoing TCP/UDP source mappings to these two addresses. If your SQL/RRAS
server has this problem, internal clients that connect to the Internet
through RRAS or ICS might be able to view only the text portion of a Web
page, but not images or embedded objects. To eliminate this problem, delete
the ReservedPorts subkey and reboot the server. For more information, see
Microsoft article "NAT Clients Cannot View Web Sites After You Install SQL
2000 SP2 on an RRAS Server" at the following URL:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q324288
John Tolmachoff
IT Manager, Network Engineer
RelianceSoft, Inc.
Fullerton, CA 92835
www.reliancesoft.com
Other related posts:
