Post reply

MSDTC not available on Windows 2022 clustered SQL 2019 CU30

  • February 21, 2025 at 11:01 am

    #4542946

    I connect to this clustered instance and run :

    begin distributed transaction

    Msg 8501, Level 16, State 3, Line 2

    MSDTC on server 'ClusteredTargetServer\Instance' is unavailable.

    I have configured the clustered msdtc of this instance:

    2025-02-21 11_59_59- - Remote Desktop Connection

     

    Test-Dtc -LocalComputerName $env:COMPUTERNAME -Verbose

    VERBOSE: ": Firewall rule for "RPC Endpoint Mapper" is enabled."

    VERBOSE: ": Firewall rule for "DTC incoming connections" is enabled."

    VERBOSE: ": Firewall rule for "DTC outgoing connections" is enabled."

    VERBOSE: ClusterNode: AuthenticationLevel: NoAuth

    VERBOSE: ClusterNode: InboundTransactionsEnabled: True

    VERBOSE: ClusterNode: OutboundTransactionsEnabled: True

    VERBOSE: ClusterNode: RemoteClientAccessEnabled: True

    VERBOSE: ClusterNode: RemoteAdministrationAccessEnabled: False

    VERBOSE: ClusterNode: XATransactionsEnabled: True

    VERBOSE: ClusterNode: LUTransactionsEnabled: True

    still this does not work.

    What else should I test ?

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • February 22, 2025 at 11:07 am

    #4543682

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply