Using SQL ODBC Through Proxy Server

• Microsoft Proxy Server version 1.0

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.
   
   
   

Keywords :
Version : WINNT:1.0
Platform : winnt
Issue type : kbinfo