How do I connect LightSwitch to SQL database which is in a shared network pc drive.

EHABELNAHAS-PC\SQLEXPRESS always gives an error no connection established to EHABELNAHAS-PC\SQLEXPRESS

OK, now 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 "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:

<



Target Name="DeploySchema"



Condition=" '$(ExecuteSchemaDeploy)' == 'true' ">

<



DeploySchema ConnectionString="$(PublishConnectionString)"

IncludeSecurityDBObjects="true"

ServerArtifactsFolder="$(_ServerArtifactsFolder)"



Collation="$(DatabaseCollation)"



IntrinsicDacPackageFilePath="$(_IntrinsicDacPackageFilePath)"



DatabaseProject="@(_DatabaseProjectItem)"



Inputs="@(ServerMetadataFiles)"

ProjectPath="$(MSBuildProjectFullPath)"/>




Please Help