Skip to content

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

Latest commit

 

History

History
60 lines (42 loc) · 2.42 KB

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

File metadata and controls

60 lines (42 loc) · 2.42 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.
ms.custom seo-lt-2019
author VanMSFT
ms.author vanto
ms.reviewer vanto
ms.date 09/24/2018
ms.topic article
ms.prod sql
ms.technology linux
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:

  1. Replication set-up involves an instance of SQL Server on Linux
  2. 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. Do not use the IP address instead of the server name. Using the IP address for the publisher, distributor, or subscriber may 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:

exec 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',  ,

Next steps

Concepts: SQL Server replication on Linux

Replication stored procedures.