Using SQL ODBC Through Proxy Server

Last reviewed: December 30, 1997
Article ID: Q170866

The information in this article applies to:

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

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:
a. Start Internet Service Manager (ISM), and select the WinSock
```
      Proxy Service.
```
b. On the Protocols tab, select Add.
c. In the Protocol Definition dialog box, type SQL SERVER for
```
      the Protocol Name.
```
d. In the Port text field, type 1433 (or the custom port
```
      specified in SQL Server Setup on the SQL Server).
```
e. Make sure that the type is TCP and the Direction is Outbound.
f. 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.

Version           : WINNT:1.0
Platform          : winnt
Hardware          : ALPHA x86
Issue type        : kbinfo

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.