Using SQL ODBC Through Proxy Server

ID: Q170866


The information in this article applies to:


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

  1. Install Microsoft SQL Server client from the Microsoft SQL Server version 6.5 compact disc.


  2. Configure your client to use TCP/IP Sockets Net Library using the SQL Server Client Configuration Utility.


  3. Install Winsock Proxy client on the SQL ODBC client.


  4. On the Proxy Server, enable Port 1433 for outbound access by:

    1. Start Internet Service Manager (ISM), and select the WinSock Proxy Service.


    2. On the Protocols tab, select Add.


    3. In the Protocol Definition dialog box, type SQL SERVER for the Protocol Name.


    4. In the Port text field, type 1433 (or the custom port specified in SQL Server Setup on the SQL Server).


    5. Make sure that the type is TCP and the Direction is Outbound.


    6. Select OK to save your configuration.




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          : 
Version           : WINNT:1.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: August 12, 1999