Share via

SQL Server linux MSDTC Support

sakuraime 2,326 Reputation points
2020-11-05T03:33:08.567+00:00

The following docuement talks about MSDTC support on Linux
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-msdtc?view=sql-server-ver15

/opt/mssql/bin/mssql-conf set network.rpcport 13500
/opt/mssql/bin/mssql-conf set distributedtransaction.servertcpport 51999

it has two setting

network.rpcport
distributedtransaction.servertcpport

and then also need a NAT rule 135 to 13500..

So does it means when the other SQL Server want to use distributed transaction to this linux server , which initially communicate using 135, and then forward the request to
13500... and then use 51999 to control the transaction ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,689 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. sakuraime 2,326 Reputation points
    2020-11-05T17:43:37.193+00:00

    anyone has the idea ?

    0 comments
  2. m 4,271 Reputation points
    2020-11-06T03:52:44.83+00:00

    Hi @sakuraime ,

    So does it means when the other SQL Server want to use distributed transaction to this linux server , which initially communicate using 135, and then forward the >request to 13500... and then use 51999 to control the transaction ?

    I think you are that. port 135 is de default port of MSDT.exe, and you can use netstat -a to test, and then port 135 directed to port 13500.And port 51999 if for DTS service.

    More information: 20-netstat-commands-for-linux-network-management

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.