SQL Server 6.5 behind Proxy Server 2.0

SQL Server 6.5 behind Proxy Server 2.0

Post by Edd » Tue, 18 Jan 2000 04:00:00

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.




SQL Server 6.5 behind Proxy Server 2.0

Post by Edd » Tue, 18 Jan 2000 04:00:00

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



The information in this article applies to:

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


This article describes how to configure Microsoft Proxy Server to reverse
proxy a computer that is running Microsoft SQL Server.


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:


      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

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


1. Problem connecting an oracle client behind Wingate proxy server to an oracle server not behind proxy

I have installed an oracle client (Forms Runtime) behind Wingate proxy
server. When I tried to connect to the server that is not behind any
proxy server I couldnt reach preferable IP (server IP). Somehow I
cant connect to destination IP.

I put in tnsnames.ora the following lines:


Client machine can connect to Internet while surfing over the Internet
with Internet Explorer but only via proxy server. Is there anything I
should put that client will first connect to proxy and to server:

Network 1 (CLIENT->PROXY)------->Netvork 2 (SERVER)

Any help is appreciated, Boris

Sent via Deja.com http://www.deja.com/
Before you buy.

2. setting inout params for ref cursor

3. Reverse Hosting SQL server behind a proxy server.

4. Attn: Software Engineers. 1995DEC28. comp.databases.sybase

5. Client access to foreign server from behind Proxy Server

6. Looking for lightweight database server for DOS or Windows...

7. SQL Server 6.5 & Proxy Server/IIS

8. Pick/Unidata/uniVerse Programmer/Analysts & Contractors needed-(U.S.-Seattle, Portland, Philly, Florida, Georgia, Maryland, etc. )-(Recruiter)

9. SQL 7.0 behind Proxy 2.0

10. SQL server 2000 and MS Proxy Server 2.0

11. Accessing Sql server through Proxy server 2.0

12. SQL Server 7 Behind Proxy 2

13. SQL Server access behind Proxy 1.0