Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 )
-
How do you configure the cluster resources to be able to use Distributed Transactions ?
Documentation ( 01/15/2014 ) is unclear and doesn't show a working solution.
Begin Distributed Transaction fails !
Msg 8501, Level 16, State 3, Line 12
MSDTC on server 'VirtSQLServer\MyInstanceName' is unavailable.
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
-
Double check these settings on each node.
Configure MSDTC network settings:Open Component Services (dcomcnfg)
Navigate to Component Services > Computers > My Computer > Distributed Transaction Coordinator
Right-click on "Local DTC" and select "Properties"
Go to the "Security" tab
Enable the following options:Network DTC Access
Allow Inbound/Outbound
Enable TIP (if needed)
Enable XA Transactions (if needed)
Also see Windows Firewall port 135 is open on each node.
=======================================================================
-
indeed.
Those settings have been activated.
DTC service has been stopped and started and is on network service
Still Begin distributed transaction fails
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
-
FWIW: We re-installed the OS and rebuilt the cluster.
Now it works as it should
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
-
Testing a bit more, it turns out, once you add a clustered MSDTC resource and remove it, it start throwing this error when running "Begin Distributed Transaction"
Even putting back the clustered MSDT resource doesn't fix the issue !!
Same player shoot again ....
Reïnstall both VM and the clustered sql server instance.
( we have now planned for a new production cluster another migration to get to a clean situation )
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply