Post reply

Is it safe to allow Network Access in MSDTC?

  • July 16, 2009 at 12:44 pm

    #212097

    Hi,

    We have a linked server. A stored procedure needs to select data on the linked server. If we have BEGIN TRAN in the SP then we got error "ITransactionJoin::JoinTransaction returned 0x8004d00a". Removing BEGIN TRAN will solve the problem but we need to use BEGIN TRAN.

    I granted "Allow Access" to NETWORK per http://support.microsoft.com/kb/873160 then it took care of the problem. Is it safe to do so? Thx.

  • July 16, 2009 at 10:04 pm

    #1025992

    I would say yes. Also, the connection still has to satisfy security on the server. I don't think MSDTC is particularly useful without this being set..

    CEWII

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

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