Error in old Csla application

[Chicagoan2016]

One of our older Csla applications starts throwing this error when we delete a record. This application persists data in two different databases (both on the same SQL instance)
"
Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool."

Thanks

[StefanOssendorf]

This sounds like a SQL Server problem to me. You must configure distributed transactions there.

[hurcane]

MSDTC is configured in Component Services. If you become familiar with the Test-Dtc powershell cmdlet, it can help diagnose configuration problems.

[Chicagoan2016]

@hurricane, here's the fun part. I brought the stored proc from say database2 to database1 and made sure the tables in the stored proc were referenced as database2.dbo.tablename....
and now it's working without configuring MSDTC

[hurcane]

That makes sense. The procedure was making cross-database calls within a transaction, which is going to require a distributed transaction. Fixing the procedure to use intra-database references won't need a distributed transaction any longer.

[rockfordlhotka]

It is good to avoid DTC if possible, as it causes a substantial performance reduction. Updating multiple databases as part of a single transaction should be done as a last resort when other patterns are unavailable.