Skip to content

sql-server-linux-replication-non-default-ports.md

Latest commit

 

History

History
59 lines (43 loc) · 2.46 KB

sql-server-linux-replication-non-default-ports.md

File metadata and controls

59 lines (43 loc) · 2.46 KB
title Configure Replication Snapshot Folder (Non-Default Ports)
titleSuffix SQL Server on Linux
description Learn to configure snapshot folder shares with non-default ports for SQL Server replication on Linux.
author rwestMSFT
ms.author randolphwest
ms.reviewer vanto
ms.date 01/21/2025
ms.service sql
ms.subservice linux
ms.topic how-to
ms.custom
linux-related-content
monikerRange >=sql-server-ver15 || >=sql-server-linux-ver15

Configure replication with non-default ports (SQL Server Linux)

[!INCLUDE SQL Server - Linux]

You can configure replication with SQL Server on Linux instances listening on any port configured with the network.tcpport mssql-conf setting. The port needs to be appended to the server name during configuration if the following conditions are true:

  • Replication set-up involves an instance of SQL Server on Linux
  • Any instance (Windows or Linux) is listening on a non-default port.

The server name of an instance can be found by running @@SERVERNAME on the instance. Don't use the IP address instead of the server name. Using the IP address for the publisher, distributor, or subscriber might result in an error.

Note

Creating SQL Server replication on Linux with non-default port will only work with SQL Server 2019 and above.

Examples

Server1 listens on port 1500 on Linux. To configure Server1 for distribution, run sp_adddistributor with @distributor. For example:

EXECUTE sp_adddistributor @distributor = 'Server1,1500';

Server1 listens on port 1500 on Linux. To configure a publisher for the distributor, run sp_adddistpublisher with @publisher. For example:

EXEC sp_adddistpublisher @publisher = 'Server1,1500' ,  ,

Server2 listens on port 6549 on Linux. To configure Server2 as a subscriber, run sp_addsubscription with @subscriber. For example:

EXEC sp_addsubscription @subscriber = 'Server2,6549' ,  ,

Server3 listens on port 6549 on Windows with server name of Server3 and instance name of MSSQL2017. To configure Server3 as a subscriber, run the sp_addsubscription with @subscriber. For example:

EXEC sp_addsubscription @subscriber = 'Server3/MSSQL2017,6549',  ,

Related content