Lightswitch Distributed Transaction with SQL Server 2005

Question

Hello,

We are using a SQL Server 2005 database with lightswitch, and are recieving a distributed transaction error in the users and roles administration screens. Users cannot be deleted through the screen, and any other changes need to be done one at a time with a Save button click in between. Is there a way to resolve this, without enabling distributed transactions?

Thank you!

---

Jewels

Answer 1

I had something similar myself, but not exactly what you're reporting.

Have a look at my blog post, to see if it perhaps sheds any light on your situation:

The version of SQL Server in use does not support datatype 'datetime2'

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.

Answer 2

Thank you for your reply. However, I have already changed the lsml values from 2008 to 2005. It did not fix this particular issue.

---

Jewels

Answer 3

Do you have data from more than one data source on the same screen?

---

Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands

If you find a reply helpful, please click "Vote as Helpful", if a reply answers your question, please click "Mark as Answer"

By doing this you'll help people find answers faster.

Answer 4

The problem is on the Lightswitch out of the box user and role screens in the administration area.

---

Jewels