Click here to Skip to main content
15,990,892 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Updated 6-Sep-14 10:34am
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900