Connect to SQL Server Through a Proxy Server (SQL Server Configuration Manager)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes how to connect to SQL Server through a proxy server in SQL Server 2017 by using SQL Server Configuration Manager. To listen remotely by way of Remote WinSock (RWS), define the local address table (LAT) for the proxy server so that the listening node address is outside the range of LAT entries.

Using SQL Server Configuration Manager

To enable connections to SQL Server through Microsoft Proxy Server

  1. Follow the steps in Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager) to determine which TCP/IP ports are used by the Database Engine, or to configure the Database Engine to use a desired port.

  2. In your proxy server define the local address table (LAT) for the proxy server so that the listening node address is outside the range of LAT entries. For more information, see your proxy server documentation.

Note

This topic applies to on-premises SQL Server. For connection issues related to SQL Database, see Troubleshoot connection issues to Azure SQL Database.