Microsoft KB Archive/170866

= Using SQL ODBC Through Proxy Server =

Article ID: 170866

Article Last Modified on 8/13/1999

-

APPLIES TO


 * Microsoft Proxy Server 1.0 Standard Edition

-



This article was previously published under Q170866



SUMMARY
It is possible to use either user-mode ODBC applications or Microsoft Internet Information Server (IIS) based database access to a Microsoft SQL Server through Microsoft Proxy Server 1.0.

This configuration can be useful if your SQL Server is outside the Proxy Server and the IIS computer is used for your intranet.

This can be accomplished by opening port 1433 on the Proxy Server in order to pass SQL Server TCP/IP Sockets communication.



MORE INFORMATION
 Install Microsoft SQL Server client from the Microsoft SQL Server version 6.5 compact disc. Configure your client to use TCP/IP Sockets Net Library using the SQL Server Client Configuration Utility. Install Winsock Proxy client on the SQL ODBC client. On the Proxy Server, enable Port 1433 for outbound access by:

 Start Internet Service Manager (ISM), and select the WinSock Proxy Service. On the Protocols tab, select Add. In the Protocol Definition dialog box, type SQL SERVER for the Protocol Name.</li> In the Port text field, type 1433 (or the custom port specified in SQL Server Setup on the SQL Server).</li> Make sure that the type is TCP and the Direction is Outbound.</li> Select OK to save your configuration.</li></ol> </li></ol>

Now your SQL ODBC Client should be able to connect to a SQL Server running TCP/IP Sockets as its transport on the external network.

Keywords: kbinfo KB170866

-

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

© Microsoft Corporation. All rights reserved.