How can we help you today? How can we help you today?

Azure Pipeline Deployment - Linked Server and DTC Error

I have a database managed by SQL Source Control that is being deployed to servers using an Azure Pipeline (with code in Azure DevOps). The target database is an Azure SQL Managed Instance. Recently, I've added a stored procedure that queries another server using a linked server. With this addition, the build succeeds, but the deployment fails with the following message.

The error 'Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x80070057(The parameter is incorrect.).' occurred when executing the following SQL:
....

I don't receive this message when I deploy the stored procedure using SQL Compare 15 with the SQL Source Control code as the source.

Is there a flag I need to set in the pipeline task to emulate SQL Compare, not to import MSDTC?

EDempster
0

Comments

2 comments

Sort by
  • EDempster
    Sorry, this one was staring me in the face, and I didn't see it. 

    Adding NoTransactions to the SQLCompareOptions in the task fixed the issue.
    EDempster
    0
  • Jon_Kirkwood
    Thanks for posting up your solution to your initial query.
    Hopefully it helps someone in the future with the same error.
    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.