ehab elnahas

ehab elnahas

  • NA
  • 1
  • 1.3k

Deploy Desktop LightSwitch with an attached SQL data source?

Sep 6 2014 4:33 PM

Hi experts,

I downloaded SQL Server 2014 and I followed the next steps:

1- I made a SQL Server Instance named: MYSQLserver

2- I Created a database called: MyDatabase attached to MYSQLserver

3- and already I attached a new LightSwitch project to that database as an external data source, and the connection string was:

"Data Source=EHABELNAHAS-PC\MYSQLserver;Initial Catalog=MyDatabase;Integrated Security=True"

4- Everything is ok, now I'm trying to publish the application, now what is the "How do you want to publish the default database?" for?? and what should I choose from the two options?

5- Second this is Visual Studio 2013 LightSwitch Publish wizard now asks me for three connection strings:
•Is the Attached Data Sources connection string
•Is the User connection string
•Is the Publish database Schema

I put the same connection string in all connection strings "EHABELNAHAS-PC\MYSQLserver;Initial Catalog=MyDatabase;Integrated Security=True" but it always give the error "An exception occurred when deploying the database for the application. Couldn't deploy package"

and when double click on it, it takes me to the error:

<DeploySchema ConnectionString="$(PublishConnectionString)"
                      IncludeSecurityDBObjects="true"
                      ServerArtifactsFolder="$(_ServerArtifactsFolder)"
                      Collation="$(DatabaseCollation)"
                      IntrinsicDacPackageFilePath="$(_IntrinsicDacPackageFilePath)"
                      DatabaseProject="@(_DatabaseProjectItem)"
                      Inputs="@(ServerMetadataFiles)"
                      ProjectPath="$(MSBuildProjectFullPath)"/>

Please Help