Lightswitch Deployment for 3-tier app

I’ve been having a problem trying to deploy my first Lightswitch app to IIS, where the first Application Administrator isn’t being created.

I kept getting an error similar to “unable to create the application administrator”.

Google eventually brought me to look at the MSDTC settings on the IIS server, but that definitely wasn’t the right direction.

However, I did find the following thread which provided the solution:

I set “enlist = false” within the web.config application string for my database connection, and this resolved the issue!

I’m still impressed by LightSwitch, although I’ve been finding myself wishing it was easier to use custom SQL queries when building the datasets.