efcore: Distributed transactions failures when running EF Core tests on main

✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(async: True, ambientTransaction: True)

Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 484

✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database(async: True, ambientTransaction: True)

Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema_test(ValueTuple`4 options) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 263

✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK

System.InvalidOperationException : The operation is not valid for the current state of the enlistment.
   at System.Transactions.EnlistmentState.Aborted(InternalEnlistment enlistment, Exception e)
   at System.Transactions.SinglePhaseEnlistment.Aborted()
   at Microsoft.Data.SqlClient.SqlDelegatedTransaction.Rollback(SinglePhaseEnlistment enlistment)
   at System.Transactions.TransactionStateDelegatedAborting.EnterState(InternalTransaction tx)
   at System.Transactions.Transaction.Rollback()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 236
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)