Share via

SQL Server linux MSDTC Support

sakuraime 2,351 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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,286 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.

    Was this answer helpful?

  2. sakuraime 2,351 Reputation points
    2020-11-05T17:43:37.193+00:00

    anyone has the idea ?

    Was this answer helpful?

    0 comments

Your answer

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