Post reply

The partner transaction manager has disabled its support for remote/network transactions

  • March 9, 2011 at 2:05 pm

    #233813

    When I try to execute a stored procedure on server a with distributed transaction which will update the data on Server B, I am getting the following error

    The partner transaction manager has disabled its support for remote/network transactions on SERVER B

    I found the following solution but I am working on windows 2008 server and I don't see security configuration under MSDTC tab?

    Right now the default coordinator is selected as Use local computer.

    How can I change the settings to allow remote/network transactions on server B?

    First verify the “Distribute Transaction Coordinator” Service is

    running on both database server computer and client computers

    1. Go to “Administrative Tools > Services”

    2. Turn on the “Distribute Transaction Coordinator” Service if it is not running If it is running and client application is not on the same computer as

    the database server, on the computer running database server

    1. Go to “Administrative Tools > Component Services”

    2. On the left navigation tree, go to “Component Services > Computers

    > My Computer” (you may need to double click and wait as some nodes

    need time to expand)

    3. Right click on “My Computer”, select “Properties”

    4. Select “MSDTC” tab

    5. Click “Security Configuration”

    6. Make sure you check “Network DTC Access”, “Allow Remote Client”,

    “Allow Inbound/Outbound”, “Enable TIP” (Some option may not be

    necessary, have a try to get your configuration)

    7. The service will restart

    8. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN’T WORK

    (This is the thing drove me crazy before)

    On your client computer use the same above procedure to open the

    “Security Configuration” setting, make sure you check “Network DTC

    Access”, “Allow Inbound/Outbound” option, restart service and computer

    if necessary.

    On you SQL server service manager, click “Service” dropdown, select

    “Distribute Transaction Coordinator”, it should be also running on

    your server computer.

    Thanks.

  • April 7, 2011 at 3:52 am

    #1308396

    Hi

    Same problem here. Found the same post as well. See below for a solution.

    http://itknowledgeexchange.techtarget.com/sql-server/how-to-configure-dtc-on-windows-2008/

    Thanks

    Saleem

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

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