Unable to create default administrator

Question

I'm trying to create 2-Tier (data access directly from user machine), Silverlight based LS application using Windows Authentication. I have set up separate database for Lightswitch security, with dedicated login having db_owner rights for this specific database. Default database is published directly to SQL Server 2005 Standard instance, I use same connection for administrator and user connection strings (for the time being), and I've set create application administrator to yes, with my Windows login set as admin user name.

When I run the application, after some loading, I get following message: "Unable to create the default administrator account. Check the server trace log for more information." Does anyone know what's causing it and where can I find trace log?

Answer 1

Ian - check out the last comment on this blog: http://blogs.msdn.com/b/lightswitch/archive/2011/09/20/diagnosing-problems-in-a-deployed-lightswitch-application-eric-erhardt.aspx that will tell you how to get the trace output on a 2-tier setup.  You'll have to enable tracing the error you'll get will be self explanatory if it's not enabled...