none
MSDTC errors after server rename RRS feed

  • Question

  • Renamed a server (Windows Server 2016 Standard) with an existing SQL Server 2016 instance on it.  Checked @@SERVERNAME to ensure the name is correct.  However, when SSIS packages are run (from SSISDB) with supported transactions, getting the following error:

    The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00E "The transaction has already been implicitly or explicitly committed or aborted"

    Checked DTC services, settings, permissions.  Even uninstalled and reinstalled DTC.

    Any assistance is greatly appreciated.  

    Monday, July 8, 2019 2:33 AM

All replies

  • Hi bukkybu,

     

    Please try to change server name in your SSIS packages and try again. Also there is a similar posting , please refer to it . Changing Server name in SSIS

     


    By the way , I think  one possibility  is that the issue may be related to SSIS instead of SQL Server Data Access . You can post your issue in the corresponding forum, and you will get professional help. SQL Server Integration Services

     

    Hope it will help you .

     

    Best Regards,

    Rachel


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, July 8, 2019 9:55 AM