Visual Studio LightSwitch will not create

Question

I am working with an old C # LightSwitch HTML project that connects to SharePoint and I need to make a few changes. Unfortunately, this is not enough to justify the transition to another technology / platform, but in any case ...

I am running Visual Studio 2015 and the project will not be built. Of course, I googled and tried everything I can think of, and, in short, even if I create a new C # LightSwitch HTML project and try to build it, it fails. Here is the error I get:

An exception occurred while creating the database for the application. An error occurred while creating the deployment plan. Deployment cannot continue. SQL0 error: Failed to load the required principal with the identifier "Microsoft.LightSwitch.DataRetentionDeploymentPlanModifier.v5.0". SQL0 error: Failed to load the required principal with identifier "Microsoft.LightSwitch.LocalDbLocationModifier.v5.0". GraphicsApp C: \ Program Files (x86) \ MSBuild \ Microsoft \ VisualStudio \ v14.0 \ LightSwitch \ v5.0 \ Microsoft.LightSwitch.targets 160

If we go to line 160 (double-click by mistake), I see this (starting from line 160):

<BuildSchema Inputs="@(ServerMetadataFiles)"
             ServerGeneratedMetadataFiles="@(ServerGeneratedMetadataFiles)"
             Collation="$(DatabaseCollation)"
             DatabaseProject="@(_DatabaseProject)"
             ProjectPath="$(MSBuildProjectFullPath)"
             OutputDirectory="Bin\Data"
             SqlExpressInstanceName="$(SqlExpressInstanceName)"
             ExternalDataSources="@(ServerExternalDataSources)"
             Condition="'$(SkipBuildSchema)' == ''"/>

, , , , . V4 , :

" ... [] "

, - , , .

Answer 1

, SQL Server Data Tools (SSDT) ?

14.0.61707.300 LightSwitch .

SSDT .

Answer 2

, 13.x SSDT , - Microsoft, .

, VS, Office Developer Tools VS,

Answer 3

...
SQL Server Visual Studio 2015 (SSDT)
SSDT 17.4 (14.0.61712.050) https://go.microsoft.com/fwlink/?linkid=863440
SSRS,
SSDT 17.3 (14.0.61709.290) https://go.microsoft.com/fwlink/?linkid=858660
.
https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017
SSDT VS2015 17.2 LightSwitch, SSRS
https://go.microsoft.com/fwlink/?linkid=852922

Answer 4

On a computer running Windows 10 with previously installed Visual Studio 2017, installing Visual Studio 2015 and starting the Lightswitch project, nothing worked, but this:

copy all content from this place "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Extensions"to"C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\140\Extensions"

Found this solution on MSDN .