How to Set Up Server Proxy with SQL Server 6.5 (185638)


The information in this article applies to:

  • Microsoft Proxy Server 2.0
  • Microsoft SQL Server 6.5
This article was previously published under Q185638

SUMMARY

This article describes how to configure Microsoft Proxy Server to reverse proxy a computer that is running Microsoft SQL Server.

MORE INFORMATION

Configure SQL Server to use TCP/IP Sockets as the default Net Library and the IP address. Add the SQL Server computer's IP address to the Proxy Server's Local Address Table. If Packet Filtering is enabled on the Proxy Server, Dynamic Packet Filtering of Microsoft Proxy Server Packets should also be selected.
  1. Create the following Wspcfg.ini file on the computer running SQL Server: 
          [sqlservr]
      ServerBindTCPPorts=1433
      Persistent=1
      KillOldSession=1
    Place this file in the same folder as the Sqlservr.exe file.(By default, this is the C:\Mssql\Binn folder.)
  2. Install the Winsock Proxy Client on the computer running SQL Server.
  3. Restart the computer so that Winsock is reset. If you do this, you do not need to stop and restart SQL Server services.
Follow these steps to test connectivity to SQL Server:
  1. Telnet to port 1433 of the Proxy Server computer's external IP address.
  2. On the SQL Server client or server (on Internet), start the client configuration utility and set it to use TCP/IP Sockets for connection. (Sockets must be installed during SQL Server setup (under the Network option) on the computer running SQL Server.
  3. Start ISQL_w and connect to the external address of the Proxy Server computer.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

216415 HOW TO: Set Up SQL Server with Proxy Server

Modification Type:MajorLast Reviewed:5/15/2003
Keywords:kbhowto KB185638
©2002 Microsoft Corporation. All rights reserved.