How to Set Up Server Proxy with SQL Server

ID: Q185638

The information in this article applies to:

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.


Additional query words: prodsql sql proxy server proxying 


Keywords          : 
Version           : WINNT:2.0
Platform          : winnt 
Issue type        : kbhowto

Last Reviewed: August 12, 1999