New LightSwitch application displays red cross and no data

Problem

A new LightSwitch application works fine when debugging with Visual Studio, but no data is shown after the application has ben published, i.e. a red cross is shown in every screen of the app.

Solution

The database connection in the Data Sources was set up to use integrated security. For debugging this works. Once deployed the application will run on the web server, the account used to access the database will be the application pool account. A simple solution is to the deploy the app with a connection with a SQL user account and specify the account and password in the connection string of ‘Other Connections’ in the LightSwitch Publish Application Wizard.

Click on the button ‘…’ to open the ‘Connection properties’ dialog

enter a SQL user name and password and use this to publish the app.