Very Computer

Hi everybody,

I have two servers, the first one is a Proxy server (IIS 4.0) and the second
one is a SQL server, I have configured the access to my SQL Server from the
internet like the article Q185638 describes.

It was working before, but I had to restart my SQL server and since that,
the socket connection is not established. It's like a Proxy issue because
when I delete the Wspcfg.ini file the ListenOn Connection at the port 1433
is succesful,and when I create the file I'm getting the following error:

Error : 17833, Severity: 18, State: 0
ListenOn connection '1433' is already in use.

I've tried to reconfigure both servers, I've reinstaled the proxy client, I
installed Proxy SP1 and after installed the proxy client again, and so...

I don't understand what is the problem.

Thanks,

Edd

PSS ID Number: Q185638
Article last modified on 09-01-1998

WINNT:2.0

winnt

======================================================================
---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Proxy Server version 2.0
 - Microsoft SQL Server version 6.5
---------------------------------------------------------------------

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.

1. 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.)

2. Install the Winsock Proxy Client on the computer running SQL Server.

3. 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.

Additional query words: prodsql sql proxy server proxying
======================================================================
Version           : WINNT:2.0
Platform          : winnt
Hardware          : x86
Issue type        : kbhowto
============================================================================
=
Copyright Microsoft Corporation 1998.