Visual Studio LightSwitch uses a database as a data source, and a 404 error occurs after publishing

This situation is due to the missing component "LightSwitch in Visual Studio 2013-server configuration with local SQL", which is installed as follows:

Http://msdn.microsoft.com/zh-cn/library/gg481779.aspx

How to: Configure a server to host LightSwitch applications

You must install the LightSwitch Server Runtime and configure Internet information Services (IIS) and SQL Server before the server can host the 3-tier LightSwitch application.

SQL Server does not have to be installed on the same server that IIS resides on. Although both must be installed, they can be located on different servers.

You can use the Web Platform installer source to download and install any missing prerequisites, including IIS and SQL Server, and configure the server. IIS 7.0 and IIS 6.0 are both supported, and IIS 7.0 will not be installed if IIS 6.0 is installed.

Install Prerequisites

--------------------------------------------------------------------------------

You will install LightSwitch server prerequisites using the Web Platform Installer 4.5 that you can download from the Microsoft Web site.

Install Prerequisites

1. On the menu bar in Web Platform Installer 4.5, select products, and then select Tools.

2. In the Search text box, enter LightSwitch, and then select the ENTER key.

3. Select the LightSwitch in Visual Studio 2013-server configuration with local SQL list item, select the Add button, and then select the Install button.  

To install the prerequisites when SQL Server is on a different server, select LightSwitch in Visual Studio 2013-server configuration with local SQL.

The name shown in Web Platform Installer 5.0 is "LightSwitch in Visual Studio 2013-server Configuration without local SQL Express".

4. If you agree to the license terms, please select the "I Accept" button.

This installs the prerequisites and configures the required settings. When the installation is complete, you can close the Web platform Installer and publish your application to the server.
--------------------------------------------------------------------------------

Visual Studio LightSwitch uses a database as a data source, and a 404 error occurs after publishing