Microsoft KB Archive/185638

= How to Set Up Server Proxy with SQL Server 6.5 =

Article ID: 185638

Article Last Modified on 5/15/2003

-

APPLIES TO


 * Microsoft Proxy Server 2.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



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.   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.)  Install the Winsock Proxy Client on the computer running SQL Server. 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

Additional query words: prodsql sql proxy server proxying

Keywords: kbhowto KB185638

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.