Skip to content

connect-to-sql-server-through-a-proxy-server-sql-server-configuration-manager.md

Latest commit

 

History

History
33 lines (27 loc) · 2.19 KB

connect-to-sql-server-through-a-proxy-server-sql-server-configuration-manager.md

File metadata and controls

33 lines (27 loc) · 2.19 KB
title Connect to SQL Server with Proxy Server-SQL Server Config Manager
description Learn how to use SQL Server Configuration Manager to connect to SQL Server through a proxy server. See how to use Remote WinSock (RWS) to listen remotely.
author rwestMSFT
ms.author randolphwest
ms.date 12/15/2016
ms.prod sql
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
Remote WinSock
RWS
LATs
proxy servers [SQL Server]
connections [SQL Server], proxy server
Microsoft Proxy Server [SQL Server]
local address tables [SQL Server]

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

[!INCLUDE SQL Server]

This topic describes how to connect to SQL Server through a proxy server in [!INCLUDEssnoversion] 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 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 [!INCLUDEssDE], or to configure the [!INCLUDEssDE] 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 [!INCLUDEssNoVersion_md]. For connection issues related to [!INCLUDEssSDS_md], see Troubleshoot connection issues to Azure SQL Database.