Skip to content

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

Latest commit

 

History

History
34 lines (27 loc) · 2 KB

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

File metadata and controls

34 lines (27 loc) · 2 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 08/26/2025
ms.service sql
ms.subservice configuration
ms.topic how-to
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 article describes how to connect to SQL Server through a proxy server in [!INCLUDE ssnoversion] 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.

Use SQL Server Configuration Manager

  1. Follow the steps in Configure SQL Server to listen on a specific TCP port to determine which TCP/IP ports are used by the [!INCLUDE ssDE], or to configure the [!INCLUDE ssDE] 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 article applies to on-premises [!INCLUDE ssNoVersion_md]. For connection issues related to [!INCLUDE ssSDS_md], see Troubleshoot connection issues to Azure SQL Database.