Note that there are some explanatory texts on larger screens.

plurals
  1. POWeb deployment task failed
    primarykey
    data
    text
    <p><img src="https://i.stack.imgur.com/whoPZ.png" alt="enter image description here"> I'm getting this error when I click Build Deployment Package. I've read a bunch of related post regarding this issue but doesn't seems to answer the questions on my mind T_T.<br/><br/> This is my connection string on my Web.Config</p> <pre><code>&lt;connectionStrings&gt; &lt;add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /&gt; &lt;add name="ProjectPALEntities" connectionString="metadata=res://*/Models.ProjectPal.csdl|res://*/Models.ProjectPal.ssdl|res://*/Models.ProjectPal.msl;provider=System.Data.SqlClient;provider connection string=';data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\ProjectPAL.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework';" providerName="System.Data.EntityClient" /&gt; &lt;/connectionStrings&gt; </code></pre> <p>This is Package/Publish SQL Settings Under Project Properties. This is where I'm having a problem. <img src="https://i.stack.imgur.com/R7Czk.png" alt="enter image description here"><br/> This is the connection string for the source database above.</p> <pre><code>data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\ProjectPAL.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework'; </code></pre> <p><br/> <strong>QUESTIONS:</strong><br/></p> <ul> <li><p>In the Connection string for the source database which is the correct one to use?</p> <p>data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\ProjectPAL.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework'; (<strong><em>this one is what I'm currently using</strong>)</em><br/></p> <p>metadata=res://<em>/Models.ProjectPal.csdl|res://</em>/Models.ProjectPal.ssdl|res://*/Models.ProjectPal.msl;provider=System.Data.SqlClient;provider connection string=';data<br> source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\ProjectPAL.mdf;integrated security=True;user<br> instance=True;multipleactiveresultsets=True;App=EntityFramework'; (<strong>with metadata or none of the above T_T</strong>)</p></li> <li><p>Where could I get the Connection string for destination database? Sorry It's my first time to deploy a website. I researched but I can't find an answer T_T.</p></li> <li><p>How could I possibly fixed this error? </p></li> </ul> <p><strong>Other Informations:</strong></p> <ul> <li><p>I changed &amp;quot with ' (single quote) after reading this reference <a href="http://blogs.msdn.com/b/rickandy/archive/2008/12/09/explicit-connection-string-for-ef.aspx" rel="nofollow noreferrer">Explicit connection string for EF</a></p></li> <li><p>I'm using Membership Provider and Role Provider and all my data is saved in ProjectPALEntities</p></li> </ul> <p>If you need more Info just tell me. :)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload