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.
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.